Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: X and Z Axis Labels Appear to Be Reversed in a 3-D Pivot Chart


View products that this article applies to.

This article was previously published under Q210766

↑ Back to the top


Symptoms

When you create a 3-D Pivot Chart in Microsoft Excel 2000, the x and z axis labels may appear to be reversed.

↑ Back to the top


Cause

This behavior can occur because the chart is three-dimensional. The x and z axis labels are positioned relative to the rotation setting of the chart.

↑ Back to the top


Resolution

To resolve this issue, rotate the chart until the x and z axis labels are positioned where you want them.

To rotate the chart, follow these steps:
1.On the Chart menu, click 3-D View.
2.In the 3-D View dialog box, click the Rotation box.
3.Enter number of degrees that you want to rotate the chart in the box, and then click OK.
NOTE: To view the degree of rotation, click Apply. To return to the original configuration, click the Default button in the 3-D View dialog box. The default rotation is 20 degrees.

↑ Back to the top


References

For more information about rotating 3-D charts, click Microsoft Excel Help on the Help menu, type change the rotation in a 3-d chart in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top


Keywords: KB210766, kbpending, kbprb

↑ Back to the top

Article Info
Article ID : 210766
Revision : 3
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 273