Microsoft Office Tutorials and References
In Depth Information
Creating Dynamic Charts by Using PivotCharts
Just as you can create PivotTables that you can reorganize on the fly to emphasize
different aspects of the data in a list, you can also create dynamic charts, or PivotCharts,
to reflect the contents and organization of a PivotTable.
Creating a PivotChart is fairly straightforward. Just click any cell in a list or Excel table
you would use to create a PivotTable, and then click the Insert tab. In the Tables group,
in the PivotTable list, click PivotChart to create the chart. To create a PivotChart from
an existing PivotTable, click a cell in the PivotTable, display the Insert tab and then, in
the Charts group, click the type of chart you want to create. After you complete either
of these procedures, Excel displays a new PivotChart in your workbook.
Any changes to the PivotTable on which the PivotChart is based are reflected in the
PivotChart. For example, if the data in an underlying data set changes, clicking the Refresh
button in the Data group on the Analyze contextual tab will change the PivotChart
to reflect the new data. Also, if you filter the contents of a PivotTable, the filter will be
reflected in the PivotChart. For instance, if you click 2006 in the Year list of a revenue
analysis PivotTable and then click OK, both the PivotTable and the PivotChart will show
only revenues from 2006.