XL97: Changing the Chart Type Changes the X-Axis (161660)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q161660

SYMPTOMS

In Microsoft Excel, when you change the chart type, the scale of the category (X) axis may also be changed.

CAUSE

This behavior occurs when you select a series and change its chart type. Changing the chart type for a series is different from changing the chart type for a group of data points. Based on the chart type you select, the "Value (Y) axis crosses between categories" check box may be cleared in the Format Axis dialog box.

WORKAROUND

To work around this behavior, follow these steps:

  1. Select the x-axis in the chart.
  2. On the Format menu, click Selected Axis, and then click the Scale tab.
  3. Click to select the "Value (Y) axis crosses between categories" check box, and then click OK.

MORE INFORMATION

For additional information on this problem in previous versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base:

110856 XL: Changing Chart Type Changes X-Axis

REFERENCES

For more information about chart types, click the Index tab in Microsoft Excel Help, type the following text

changing chart types

and then double-click the selected text to go to the "Select a Different Chart Type" or "Change the Spacing of Tick Marks and Labels on the Category Axis" topic.
Modification Type:MajorLast Reviewed:10/22/2000
Keywords:kbchart kbprb kbualink97 KB161660
©2002 Microsoft Corporation. All rights reserved.