Microsoft Office Tutorials and References
In Depth Information
Working with multiple axes
When you start experimenting with combination charts, you’ll quickly discover
that all 3-D charts are off limits for combination charts. You’ll also find that some
combinations are of limited value. For example, it’s unlikely that anyone would
need to create a chart that combines a radar chart and a line chart.
The combination chart shown in Figure 3-23 is an extreme example. It combines
five chart types: area, column, line, pie, and XY. I resisted the urge to toss in a
series formatted as a radar chart. This is for demonstration purposes only and is
certainly not an example of an effective chart!
A combination chart uses a single Plot Area. Therefore, it’s not possible to
create, say, a combination chart that displays three pie charts.
Working with multiple axes
A chart can use zero, two, three, or four axes, and any or all of them can be hidden
if desired.
Figure 3-23: This combination chart is comprised
of five chart types.
Pie charts and doughnut charts have no axes. Common chart types, such as a
standard column or line chart, use a single category axis and a single value axis. If your
chart has at least two series — and it’s not a 3-D chart — you can create a secondary
Search JabSto ::




Custom Search