Intermediate Excel · Interactive lesson 9 of 12
Pivot charts, slicers & simple dashboards
A PivotChart turns the same summary into a picture, and a slicer turns that picture into something a non-spreadsheet person can filter themselves — click a button instead of hunting through a dropdown.
Screens shown: Excel for Microsoft 365 for Windows. Practice works in any browser.
Written tutorialPivotCharts, Slicers and Simple Dashboards in ExcelSkill check
Try these first:
- Build a PivotChart from a PivotTable.
- Add a slicer and use it to filter the chart.
- Explain what makes a one-page dashboard readable instead of cluttered.
- Write a chart title that tells the reader what they're looking at.
All familiar? Skip ahead to I10 — Data Cleanup & Import.
Targeted teach
What you're learning
- PivotChart basics
- Built straight from a PivotTable — filter or regroup the table and the chart updates with it.
- Slicers
- Clickable buttons for one field — insert a slicer for Region and anyone can filter the whole view without touching a dropdown.
- Timelines
- A slicer built specifically for date fields — drag to select a date range instead of picking individual months.
- Dashboard layout discipline
- Group related charts together, keep a consistent size and spacing, and leave visual breathing room.
- Titles that explain the view
- "Sales" tells you nothing a chart doesn't already show — "Sales by Region, Q4" tells you what changed and when.
- Avoiding clutter
- Every extra gridline, 3-D effect, or unnecessary legend is one more thing between the reader and the answer.
Where to find it in Excel
PivotTable Analyze›Insert Slicer · Insert Timeline · PivotChart
| A | B | C | D | E | F | G | H | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | Row Labels | Sum of Amount | |||||||
| 2 | East | 3,250 | |||||||
| 3 | North | 6,900 | |||||||
| 4 | South | 5,400 | |||||||
| 5 | West | 4,880 | |||||||
| 6 | Grand Total | 20,430 | |||||||
| 7 | |||||||||
| 8 | |||||||||
| 9 | |||||||||
| 10 |
Swipe sideways to see the whole window.
- 1Click inside the PivotTable to show PivotTable Analyze.
- 2PivotChart draws a chart that follows the PivotTable.
- 3Insert Slicer adds clickable filter buttons.
- 4Insert Timeline filters by date ranges.
- 5The selected button shows what the report is filtered to.
Rendered view of Excel for Microsoft 365 (Windows). Ribbon layout can differ slightly on Mac, Excel for the web or a narrow window.
Guided practice
Click Region and Category chips to filter — the chart rebuilds from whatever's still selected.
Independent variation
Build a one-page summary
Build a PivotChart with at least two slicers over data you actually track. Give it a title that states what it shows and for what period, and remove anything — gridlines, extra legends, a second chart type — that doesn't help the reader answer the question faster.
Spot a mistake or have an idea for this lesson? Send feedback