Lesson 8.2 – Creating Interactive Charts & Pivot Charts

Lesson Overview

Interactive charts and Pivot Charts allow users to analyze data dynamically. This lesson teaches how to create Pivot Tables, Pivot Charts, and add interactive elements like slicers and timelines to build user-friendly dashboards.

1. Introduction to Pivot Charts

• Pivot Charts are visual representations of Pivot Tables

• Automatically update when Pivot Table data changes

• Ideal for summarizing large datasets

2. Creating a Pivot Table

2.1 Steps

1. Select the dataset → Insert → PivotTable

2. Choose location (New Worksheet or Existing Worksheet)

3. Drag fields into Rows, Columns, Values, and Filters

4. Format numbers, text, and labels

2.2 Example

• Analyze sales by region and product category

• Rows: Region, Columns: Product Category, Values: Sum of Sales

3. Creating Pivot Charts

3.1 Steps

1. Select Pivot Table → Insert → PivotChart

2. Choose chart type (Column, Line, Bar, Pie, etc.)

3. Pivot Chart updates automatically with Pivot Table changes

3.2 Example

• Column chart showing monthly sales per region

• Add data labels for clarity

4. Adding Interactivity with Slicers & Timelines

4.1 Slicers

• Go to PivotTable Analyze → Insert Slicer

• Filter data visually by categories like Region, Product, Department

• Example: Click on a region to view sales data for that region only

4.2 Timelines

• Go to PivotTable Analyze → Insert Timeline

• Filter date-based data dynamically

• Example: View sales by month, quarter, or year

5. Best Practices for Interactive Charts

1. Keep the number of slicers manageable

2. Use consistent colors across charts

3. Align charts and slicers for a clean layout

4. Ensure charts are legible and easy to interpret

5. Combine multiple charts for a comprehensive dashboard

6. Real-Life Examples

• Sales Dashboard: Filter by region and month using slicers and timelines

• HR Dashboard: View employee data by department and join date dynamically

• Finance Dashboard: Compare revenue vs. expense across quarters

• Operations Dashboard: Track inventory levels by warehouse and product category

7. Practice Questions

1. Create a Pivot Table from a sales dataset showing region-wise sales totals.

2. Insert a Pivot Chart and choose the appropriate chart type for trends analysis.

3. Add a slicer for product categories and test interactivity.

4. Insert a timeline to filter data by month and quarter.

5. Explain why Pivot Charts are preferred for interactive dashboards.