Help and Support

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

View products that this article applies to.
Article ID:174170
Last Review:December 12, 2002
Revision:1.0
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.

Back to the top

CAUSE

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

Back to the top

WORKAROUND

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

APPLIES TO
•Microsoft Excel 97 Standard Edition

Back to the top

Keywords: 
kbchart kbinfo KB174170

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.