PivotTables

Create a PivotChart

Create a PivotChart

Sometimes it's hard to see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table and quickly see what's going on. PivotCharts are a great way to add data visualizations to your data.

Household expense data

Corresponding PivotChart

Sample household expense data to create a PivotTable with Months, Categories and Amounts

Example of an Excel PivotChart

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Create a PivotChart

  1. Select a cell in your table.

  2. Select Insert > PivotChart PivotChart option on the ribbon .

  3. Select OK.

Create a chart from a PivotTable

  1. Select a cell in your table.

  2. Select PivotTable Tools > Analyze > PivotChart PivotChart option on the ribbon .

  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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×