Microsoft Office Tutorials and References
In Depth Information
Turning Data into a Chart
If the data source for your chart is a PivotTable, the result is a PivotChart. What’s the
difference? The most noticeable change from a regular chart is the addition of field buttons,
which you can use to filter data just as in a PivotTable. When you click to select any part
of a PivotChart, Excel displays a group of custom tabs under the PivotChart Tools heading.
As Figure 13-4 shows, the first three tabs are identical to the Chart Tools tabs you use with
a regular chart. The Analyze tab includes a Field Buttons menu that allows you to show or
hide specific types of field buttons.
When you filter data using field buttons in a PivotChart, your changes are immediately
reflected in the underlying PivotTable. All other procedures for formatting a PivotChart and
changing its layout are similar to the techniques used with a regular chart.
For a detailed discussion of how to create and manipulate PivotTables, see “Using PivotTables”
on page 406.