Microsoft KB Archive/211409

= XL2000: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 2000 =

Article ID: 211409

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211409





SYMPTOMS
When you create a column or an area chart in a workbook in Microsoft Excel 5.0c or Excel 7.0, and then open the workbook in Excel 2000, the y-axis is rescaled. For example, if the y-axis scale for the chart in Excel 5.0c or Excel 7.0 uses numbers from 0 through 25, the y-axis scale for the chart uses numbers from 0 through 30 when you open the workbook in Excel 2000.



CAUSE
Microsoft added this feature to Excel to improve the appearance of charts.



WORKAROUND
To work around this behavior, double-click the y-axis; click the Scale tab and change the value in the Maximum box or Major unit as necessary.

Additional query words: charts XL2000

Keywords: kbchart kbprb KB211409

-

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

© Microsoft Corporation. All rights reserved.