Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

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.

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 and choose  Pivot Chart button PivotChart.

  3. Select where you want the PivotChart to appear.

  4. Select OK.

  5. Select the fields to display in the menu.

Household expense data

Corresponding PivotChart

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

Example of an Excel PivotChart

Create a chart from a PivotTable

  1. Select a cell in your table.

  2. Select Insert and choose PivotChart.

  3. Select a chart.

  4. Select OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.