XL97: Changing the Chart Type Changes the X-Axis This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
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:
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 (http://support.microsoft.com/kb/110856/EN-US/)
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.
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
