Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Figure 15-4: Your pivot chart displays the same fields your underlying pivot table displays.
In addition, selecting a Business Segment from the Page field filter filters both the pivot table and the
pivot chart. All this behavior occurs because pivot charts use the same pivot cache and pivot layout
as their corresponding pivot tables. Thus, if you add or remove data from your data source and
refresh your pivot table, your pivot chart updates to reflect the changes.
Take a moment to think about the possibilities. You can essentially create a fairly robust interactive
reporting tool on the power of one pivot table and one pivot chart; no programming is necessary.
Understanding the link between pivot charts
and pivot tables
The primary rule to remember is that your pivot chart is merely an extension of your pivot table. If
you refresh, move a field, add a field, remove a field, hide a data item, show a data item, or apply a
filter, your pivot chart reflects your changes.
One common mistake people make when using pivot charts is assuming that Excel will place the
values in the column area of the pivot table in the x-axis of the pivot chart.
For instance, the pivot table in Figure 15-5 is in a format that’s easy to read and comprehend. The
structure chosen shows Sales Periods in the column area and the Region in the row area. This structure
works fine in the pivot table view.
Figure 15-5: The placement of your data fields may work for a pivot table, but not for a pivot chart.