Dashboard Mode - Pie and doughnut charts
Dashboard Goal
Show how sales are divided among different product categories using pie and doughnut charts.
0
0
Pie and doughnut charts in Excel - Dashboard Guide
Sample Data
| Category | Sales |
|---|---|
| Books | 120 |
| Electronics | 300 |
| Clothing | 180 |
| Home | 100 |
| Sports | 150 |
Dashboard Components
- Total Sales (KPI Card): Shows total sales across all categories.
Formula:=SUM(B2:B6)
Result: 850 - Pie Chart: Visualizes sales share by category.
Data range:A2:B6
Shows each category slice sized by sales. - Doughnut Chart: Also shows sales share by category but with a hole in the center.
Data range:A2:B6
Useful for comparing with other data or showing total in center.
Dashboard Layout
+----------------------+----------------------+ | Total Sales (KPI) | Pie Chart | | | | | 850 | (Pie chart here) | +----------------------+----------------------+ | Doughnut Chart | | (Doughnut chart here) | +---------------------------------------------------------+
Interactivity
Add a filter to select one or more categories. When you pick categories, the Total Sales number, Pie Chart, and Doughnut Chart update to show only the selected categories' sales.
Self Check
If you add a filter to show only 'Books' and 'Clothing', which components update and what is the new total sales?
Answer: Total Sales updates to 300 (120 + 180). Pie and Doughnut charts update to show only these two categories.
Key Result
Dashboard shows total sales and sales share by category using pie and doughnut charts.