XL2000: Changing the Chart Type Changes X-Axis (211942)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211942

SYMPTOMS

In Microsoft Excel 2000, 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.

REFERENCES

For more information about chart types, click Microsoft Excel Help on the Help menu, type select a different chart type in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbchart kbprb KB211942
©2003 Microsoft Corporation. All rights reserved.