Microsoft Office Tutorials and References
In Depth Information
Choosing the Right Chart Type
Figure 13-4 Use the field buttons on a PivotChart to filter the data from the linked PivotTable.
The icon to the right of the Station field indicates that we’ve filtered that field.
Choosing the Right Chart Type
As we noted earlier, you must select a chart type and subtype to create a chart initially, but
you can switch to a different subtype or even choose a completely different chart type later.
Click to select any part of the chart, and then click the Change Chart Type command on the
Design tab to open the dialog box shown in Figure 13-5.
Column Charts
Column charts are tailor-made for side-by-side comparisons, especially over time. Available
subtypes include clustered columns, stacked columns, and 100% stacked columns, with and
without 3-D effects. Figure 13-6, for example, shows a clustered column chart that offers a
simple comparison of revenues in four regions over four years. It’s easy to see at a glance
that revenues in the North and East regions have been lat or down slightly over time, while
the South and West regions have grown impressively.
Search JabSto ::

Custom Search