Microsoft Office Tutorials and References
In Depth Information
items. The category labels are lengthy, and it would be difficult to display them
legibly using a column chart.
Table 2-3 lists Excel’s six bar chart subtypes.
3-D or Not 3-D? That Is the Question
Some of Excel’s charts are referred to as 3-D charts . This terminology can be a bit
confusing, because some of these so-called 3-D charts aren’t technically 3-D charts.
Rather, they are 2-D charts with a perspective look to them; that is, they appear to
have some depth. The accompanying figure shows two “3-D” charts.
The chart on the left isn’t a true 3-D chart. It’s simply a 2-D chart that uses
perspective to add depth to the columns. The chart on the right is a true 3-D chart
because the data series extend into the third (depth) dimension.
A true 3-D chart has three axes: a value axis (the height dimension); a category axis
(the width dimension); and a series axis (the depth dimension). The series axis is
always a category axis — it cannot depict scaled numerical values.
When a 3-D chart is active, you can select Chart
3-D View to change the chart’s
perspective using the 3-D View dialog box. You’ll find that you have a great deal of
control. You can distort the chart so much that it becomes virtually unrecognizable.