Microsoft KB Archive/174170

= XL97: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 97 =

Article ID: 174170

Article Last Modified on 12/12/2002

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q174170





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 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.



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



WORKAROUND
To work around this behavior, double click the axis, click the Scale tab and change the Maximum or Major Unit box as necessary.

Additional query words: charts

Keywords: kbinfo kbchart KB174170

-

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

© Microsoft Corporation. All rights reserved.