In Microsoft Excel 97 and Microsoft Excel 2000, when you change your chart from a two-dimensional to a three-dimensional chart type, the order in which the data series categories are displayed in your chart may be reversed.
↑ Back to the top
This problem may occur when you do the following:
| 1. | You create a two-dimensional bar chart. |
| 2. | You format the vertical category axis of your chart with the following Scale options:| � | Value (Y) axis crosses between categories | | � | Categories in reverse order |
|
| 3. | You change your chart type to 3-D Bar Chart. |
This problem may also occur when you do the following:
| 1. | You create a two-dimensional column chart. |
| 2. | You format the horizontal category axis of your chart with the following Scale options:| � | Value (Y) axis crosses between categories | | � | Categories in reverse order |
|
| 3. | You change your chart type to 3-D Column Chart. |
↑ Back to the top
To work around this problem, change the order in which your data series categories are displayed. To do this, follow these steps:
| 1. | On the chart, click to select the data series that you want.
Notice that the Name box contains the name of the selected data series. |
| 2. | On the Format menu, click Selected Data Series. |
| 3. | Click the Series Order tab. In the Series order list, click the series that you want, and then click Move Up if you want to move the series up, or click Move Down if you want move the series down. |
| 4. | Click OK. |
↑ Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
↑ Back to the top
For more information about charts, click Microsoft Excel Help on the
Help menu, type charts in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
↑ Back to the top