Microsoft KB Archive/283017

= XL2000: XY Scatter Chart Distorted If You Change XY (Scatter) Chart Axes =

Article ID: 283017

Article Last Modified on 10/9/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q283017



SYMPTOMS
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.



CAUSE
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



MORE INFORMATION
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.

Additional query words: excel2000 excel2k xl2000 xl2k chart scatter distort problem prb

Keywords: kbprb KB283017

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.