Series Order Is Reversed When Chart Type Is Changed to 3-D (154848)
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0a
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.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 8/15/2003 |
|---|
| Keywords: | kbbug kbpending KB154848 |
|---|
|