XL2000: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 2000 (211409)


The information in this article applies to:

  • Microsoft Excel 2000
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.
Modification Type:MajorLast Reviewed:9/27/2003
Keywords:kbchart kbprb KB211409
©2003 Microsoft Corporation. All rights reserved.