Article ID: 154848
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 95a
- Microsoft Excel 5.0c
- Microsoft Excel 5.0a for Macintosh
This article was previously published under Q154848
SYMPTOMS
In Microsoft Excel 5.0 and Microsoft Excel 7.0, if you change the chart type of a two-dimensional
column or bar chart to a three-dimensional (3-D) column or bar chart, the
order of the series for each category may be reversed in the chart.
CAUSE
This problem occurs if both of the following conditions are true:
- In the column or bar chart, you select the following options for the
category axis (the horizontal axis in a column chart or the vertical
axis in a bar chart):
Value (Y) Axis Crosses between Categories
Categories in Reverse Order
- You change the chart type from a two-dimensional chart to a 3-D chart.
WORKAROUND
To work around this problem, follow these steps:
- On the Format menu, click Chart Type.
- In the Chart Type dialog box, click Options.
- In the Format 3-D Bar Group or Format 3-D Column Group dialog box, click the Series Order tab.
- On the Series Order tab, click a series listed under Series Order, and then click either Move Up or Move Down to change the order of the series.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
REFERENCES
"Getting Results with Microsoft Excel for Windows 95," pages 88-92, 99-100
"User's Guide," version 5.0, pages 259-297, 310
For more information about chart series in Microsoft Excel version
7.0, click
Answer Wizard on the
Help menu and type:
how to change the order of a chart series
For more information about chart series in Microsoft Excel version
5.0, click
Search in Help and type:
Choose the
Show Topics button, select the topic, and choose
Go To.
Additional query words: 5.00a 5.00c XL
Keywords: kbbug kbpending KB154848