Microsoft Office Tutorials and References
In Depth Information
Modifying 3-D charts
Not all charts that are labeled “3-D” are true 3-D charts. A true 3-D chart has
three axes. Some of Excel’s 3-D charts are simply 2-D charts with a
perspective look to them.
Modifying 3-D charts
All 3-D charts have a few additional parts that you can customize. For example,
most 3-D charts have a floor and walls, and the true 3-D charts also have an
additional axis (the series axis). You can select these chart elements and format them to
your liking. To change the depth of a 3-D chart, you need to go to the options tab
of the Format Series dialog box (not the Format Floor dialog box, as you might
expect).
Figure 4-39 shows a 3-D column chart that uses the default settings (left) and
the same chart after making some formatting changes in the Options tab of the
Format Series dialog box. In this case, the gap depth and gap width were decreased
and the chart depth was increased. It’s not possible to change these parameters for
a particular series. Changing them for one series changes them for all the series.
Rotating 3-D charts
When you start flirting with the third dimension, you have a great deal of flexibility
regarding the viewpoint for your charts. Figure 4-40 shows a 3-D column chart that
has been rotated to show four different views. It should be obvious that Excel allows
you to rotate a 3-D chart in such a way that it becomes virtually incomprehensible.
Figure 4-39: A few simple formatting changes make a dramatic difference
in the look of this 3-D column chart.
Search JabSto ::




Custom Search