✅ Excel Basics Part 9: Pivot Tables and Pivot Charts

Think of a pivot table as a summary machine. You give raw data. It gives answers.

Start with raw data
Imagine this table has 5,000 rows.
Date | Region | Product | Sales
Jan | North | Laptop | 50000
Jan | South | Mobile | 30000
Feb | North | Mobile | 20000
…and more rows

Looking at this data directly wastes time.

What a Pivot Table does
• Groups similar data
• Adds numbers automatically
• Shows summary in seconds

Example 1. Total sales by region
Question How much sales happened in each region?
Steps
• Select the data
• Insert → Pivot Table
• Drag Region to Rows
• Drag Sales to Values
Result
North → 70,000
South → 30,000
No formula used.

Example 2. Sales by product
Question Which product sells more?
Steps
• Rows → Product
• Values → Sum of Sales
Result
Laptop → total sales
Mobile → total sales

Example 3. Monthly sales trend
Question How does sales change month by month?
Steps
• Rows → Date
• Values → Sum of Sales
Now you see Jan, Feb, Mar totals clearly.

Values area. Important part
This decides what calculation happens.
Common options
• Sum. Total sales
• Count. Number of records
• Average. Mean score
• Percentage of total. Share comparison
Example Region sales as percent of total sales.

Filters and slicers. Easy control
Filters
• Drop-down inside pivot
• Select one region or one product
Slicers
• Big buttons
• One click filtering
• Used in dashboards
Example Click North. Entire pivot updates.

Pivot Chart. Visual version
A pivot chart is a chart linked to a pivot table.
Key rule Change pivot. Chart updates automatically.
Example
• Pivot shows sales by month
• Pivot chart shows line trend
How to create
• Click pivot table
• Insert → Pivot Chart
• Choose Column or Line
Best uses
• Column chart for comparison
• Line chart for trends
• Bar chart for ranking

Real-life example
Sales dashboard
• Pivot table for calculations
• Slicers for year and region
• Pivot chart for management view

Common mistakes
• Blank column headers in data
• Merged cells
• Editing pivot numbers manually

Interview tip
Say this clearly Pivot tables summarize large data without formulas and update instantly when data changes.

Double Tap ♥️ For More