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 97, 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 97.
Back to the top
Microsoft added this feature to Excel 97 to improve the appearance of charts.
Back to the top
To work around this behavior, double click the axis, click the
Scale tab
and change the
Maximum or
Major Unit box as necessary.
Back to the top