XY (scatter) charts are displayed incorrectly when you change the maximum values of the x- or y-axis scale to be significantly less than the largest number plotted.
↑ Back to the top
The amount that you must reduce the axis for the symptoms to occur depends on the following factors:
| � | Video display resolution (640 x 480, 800 x 600, and so forth) |
| � | Zoom percentage of the active window in Excel |
| � | Size (ratio) of the plot area within the chart |
↑ Back to the top
Microsoft Excel scales the endpoints for each segment drawn, and stores them as pixel coordinates. Excel limits pixel coordinates to a maximum of 32 kilobytes (KB) of memory when you chart data points defined by the axis scales.
If you manually reduce the maximum axis value to a small fraction of the default size, the pixel coordinates for the end of the segment may exceed the 32 KB limit. When this happens, Excel does not rescale the segment end points when it draws the segment, and the segment may show an incorrect slope.
↑ Back to the top