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

ID: Q211409

The information in this article applies to:

Microsoft Excel 2000

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
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb