Microsoft Office Tutorials and References
In Depth Information
Creating dynamic charts by using PivotCharts
Creating dynamic charts by
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 that
you would use to create a PivotTable, and then click the Insert tab. In the Charts group,
click the PivotChart button to create the chart. When you do, Excel 2013 opens the Create
PivotChart dialog box.
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.