Creating a PivotChart
A PivotChart can be created to plot the data from a PivotTable and provide a graphical representation. PivotChart's are interactive and their layout can be changed just like you would with a PivotTable.
- Select a cell in the PivotTable
- Click the Chart Wizard button on the PivotTable toolbar
- A chart is inserted onto a new worksheet
If the PivotTable toolbar is not displayed, right click on any toolbar button and select PivotTable from the list of toolbars that appears.
The Chart toolbar appears providing features to help you work with the PivotChart.
If the PivotTable is updated, the PivotChart will automatically update to plot the latest data.