Microsoft Office Tutorials and References
In Depth Information
Creating a 3-D Chart
horizontally or vertically. Increasing the rotation horizontally spins the chart clockwise
(as seen from above); increasing the rotation vertically raises the user’s viewpoint higher
above the chart. Often you’ll need to experiment to ﬁ nd the right angles for a 3-D chart
by rotating the chart in different directions until it looks good without distorting the data.
Excel charts cannot be rotated around the z- or depth axis, but you can specify the
chart’s depth. Depth values can range from 0 to 2000 units. The larger the value, the
thicker or deeper the chart appears to extend away from the viewer. You can also change
the chart’s perspective , which controls how fast the chart appears to recede from the
viewer’s eye. Perspective values range from 0 degrees to 90 degrees. A 90 degree
perspective value exaggerates the 3-D effect, making distant objects appear very small,
whereas perspective values near 0 degrees minimize this effect. Excel immediately
applies your choices for depth and perspective, so you can try different depth and
perspective values to determine which work best for your chart.
You’ll rotate the Allocation of Assets pie chart along the horizontal axis so that the
largest slice is on the left side of the pie. You’ll also orient the chart so that the viewer’s
eye level is slightly above the chart. You will not change the chart’s perspective or depth.
To rotate and reorient the 3-D pie chart:
1. Click the Chart Tools Layout tab on the Ribbon.
2. In the Background group, click the 3-D Rotation button. The Format Chart Area
dialog box opens with the 3-D Rotation options displayed.
3. In the Rotation section, type in the X box, and then type in the Y box. See 20
Format Chart Area dialog box with 3-D Rotation options
You can use the 3-D
Format options to add
drop shadows, raised
or beveled corners, and
textured surfaces that give
the illusion of light
reflecting off the chart elements.
4. Click the Close button. The pie chart rotates based on the new x-axis and y-axis
values. See Figure 4-35.