Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Figure 15-2: Select the chart type you want to use.
Figure 15-3: Excel creates your pivot chart on the same sheet as your pivot table.
You can easily change the location of your pivot charts by simply right-clicking on the chart (outside
the plot area) and selecting Move Chart. This activates the Move Chart dialog box, where you can
specify the new location.
In Figure 15-3, notice the pivot field buttons on the pivot chart — the gray buttons with
drop-down arrows. Using these pivot field buttons, you can rearrange the chart and
apply filters to the underlying pivot table.
If you aren’t too keen on showing the pivot field buttons directly on your pivot charts,
you can remove them by clicking on the chart and selecting the Analyze tab. On the
Analyze tab, you can use the Field Buttons drop-down button to hide some or all of the
pivot field buttons.
You now have a chart that is a visual representation of your pivot table. Moreover, because the pivot
chart is tied to the underlying pivot table, changing the pivot table in any way changes the chart. For
example, as Figure 15-4 illustrates, adding the Region field to the pivot table adds a region
dimension to your chart.