Explanation

A PivotChart is a chart connected to a PivotTable.

When the PivotTable changes, the PivotChart can update accordingly.

Common PivotCharts

• Column
• Bar
• Line
• Pie
• Doughnut
• Area

Example

PivotTable:

Create a Column PivotChart to compare product sales.

Steps

1. Select the PivotTable.
2. Go to Insert → PivotChart.
3. Select a chart type.
4. Format the chart.
5. Add a meaningful title.

Practice

Create:

• Product Sales Chart
• City Sales Chart
• Monthly Sales Chart