A PivotChart is similar to an ordinary chart created in Excel, except that it plots a PivotTable’s information. Like PivotTable reports, PivotCharts are dynamic, which means you can change a PivotChart by updating the values in a PivotTable.
- Click any cell inside the PivotTable.
The Analyze and Design tabs appear under PivotTable Tools on the ribbon.
- Click the Analyze tab on the ribbon.
- Click the PivotChart button.
The Insert Chart dialog box lets you choose from a variety of PivotChart types. Some chart types will be better at displaying certain data than others.
The most common types of charts are Column, Bar, Line, and Pie.
- Column and Bar charts work well to compare different sets of data against each other.
- Line and Area charts are great for showing trends over time.
- Pie charts show different categories as parts of a whole.
- Select the type of chart you want to use.
- Click OK.
The chart appears in the worksheet with your PivotTable. You can click and drag to reposition it and use the resize handles to scale it, just like with any other object.
Just like with PivotTables, there are four areas in the PivotChart Fields pane to which you can add fields. The look of your chart will change depending on the area you place the fields in.
- If necessary, expand the Show/Hide group on the Analyze tab.
- Click the Field List button.
- Drag fields into or out of the task pane areas to change the data displayed in the PivotChart.
Any changes you make to the PivotChart are automatically applied to the PivotTable as well. The values in each will always match.
The PivotChart instantly updates to show the data for any fields that have been added.
When a PivotChart is selected, a new set of tabs appear in the ribbon.