Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Column and Area Chart Y Axis Is Scaled in Microsoft Excel 2000

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

↑ Back to the top

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

Keywords: KB211409, kbprb, kbchart

↑ Back to the top

Article Info
Article ID : 211409
Revision : 4
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 249