Pivot Charts

A Pivot Chart is an interactive chart that is directly connected to a Pivot Table. It helps users visualize summarized data using charts without creating formulas manually.

Whenever the Pivot Table changes, the Pivot Chart automatically updates. Pivot Charts are widely used in dashboards, reports, sales analysis, student performance analysis, and management reporting.

What is the Difference Between a Normal Chart and a Pivot Chart?

Student Marks Dataset Used

We will use the same marksheet dataset that contains the following columns:

Creating a Pivot Chart

Step-by-Step Process

1. Select any cell inside the dataset.
2. Click Insert → PivotTable.
3. Choose New Worksheet.
4. Create the required Pivot Table.
5. Click anywhere inside the Pivot Table.
6. Select PivotTable Analyze → PivotChart.
7. Choose the required chart type.
8. Click OK.

Exercise 1 – Total Students in Each Grade

Pivot Table Fields

Recommended Chart

• Column Chart
• Pie Chart

Report Generated

Shows how many students received A+, A, B+, B, C+, C, and Fail grades.

Exercise 2 – Pass vs Fail Analysis

Recommended Chart

• Pie Chart
• Doughnut Chart

Shows the percentage of students who passed and failed.

Exercise 3 – Subject Wise Average Marks

Recommended Chart

• Column Chart
• Bar Chart

Compare average performance across all subjects.

Exercise 4 – Top 10 Students by Total Marks

Apply Value Filter → Top 10.

Recommended Chart

• Bar Chart

Exercise 5 – Grade Wise Average Marks

Recommended Chart

• Column Chart

Compare overall performance for each grade category.

Using Slicers with Pivot Charts

Slicers provide clickable buttons that allow users to filter Pivot Tables and Pivot Charts instantly.

Steps to Add a Slicer

1. Select the Pivot Table.
2. Click PivotTable Analyze.
3. Select Insert Slicer.
4. Choose Grade.
5. Choose Result.
6. Click OK.

Now when you click Grade A+, only A+ students will appear in both the Pivot Table and Pivot Chart.

Best Chart Selection Guide