Create a PivotChart

Sometimes it can be hard to see the big picture when you have raw data that hasn't been summarized, like the example below. Many times, your first step will be to create a PivotTable to summarize and analyze your data in a structured format, which is well and good, but not everyone can look at numbers and quickly see what's going on. PivotCharts are a great way to add data visualizations to your data.

Household expense data	Corresponding PivotChart

Windows macOS



Create a PivotChart

1. Select a cell in your table.

2. Select Insert > PivotChart .

3. Select OK.

Create a chart from a PivotTable

1. Select a cell in your table.

2. Select PivotTable Tools > Analyze > PivotChart .

3. Select a chart.

4. Select OK.

To create a PivotChart on the Mac, you need to create a PivotTable first, and then insert a chart. Once that is done, the chart will behave like a PivotChart if you change the fields in the PivotTable Fields list. 

1. Create a PivotTable if you don't have one already. 

2. Select any cell within the PivotTable.

3. On the Insert tab, click a button to insert either a column, line, pie, or radar chart. Please note that other types of charts do not work with PivotTables at this time. For example, treemap charts, statistical charts, and combo charts do not work with PivotTables yet.

4. After you insert a column, line, pie, or radar chart, you can pivot it by changing or moving fields using the PivotTable Fields list.

5. You can also filter data in a PivotTable, and use slicers. When you do that, the chart will also be filtered.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Create a PivotTable

Use the Field List to arrange fields in a PivotTable

Use slicers to filter data

Create a PivotTable timeline to filter dates