How to create Pivot charts on Excel?

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

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.

Corresponding PivotChart