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

View products that this article applies to.

This article was previously published under Q211409

Expand all | Collapse all

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.

Back to the top

CAUSE

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

Back to the top

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.

Back to the top