Excel: Charts Not Pasting Correctly into Drawing Programs

SUMMARY

In Microsoft Excel, if the value axis of a chart has been formatted so that it includes less information than the selected data on the worksheet, the series will reflect the original proportions (before the axis scale was changed) when pasted into a drawing application.

For example, a chart is created that contains data that extends to 5 on the value axis and the value axis is formatted to show data only up to 4. This formatting crops the column at 4, even though it has an actual value of 5. The chart is then copied into a drawing application and the column extends to 5, even though the value axis extends only to 4.

The only way to solve this problem is to make the necessary revisions in the drawing application.

This problem will not occur if the chart is copied into a painting application.

MORE INFORMATION

When the value axis is changed to crop data in a chart, the chart still contains all of the information, but the drawing has been suppressed.

Draw programs display the suppressed portions of the drawing as well as the portion that is desired. A paint program imports a bitmap of the picture that is copied from Excel.