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 PivotChart button in the Tools group of the Options tab
- Select the type of chart you would like to use
- Click Ok
The PivotTable Tools contextual menus are displayed on the ribbon
The Insert Chart dialogue box appears.
The PivotChart appears in the worksheet with the PivotTable.
The PivotChart Filter Pane is displayed alongside the PivotTable Field List. This pane can be used to select the data you want the chart to display.
PivotChart Tools contextual tabs appear on the Ribbon providing plenty of features to help you work with the PivotChart.
If the PivotTable is updated, the PivotChart will automatically update to plot the latest data.