Sparklines in Excel - Dashboard Guide

Dashboard Mode - Sparklines

Dashboard Goal

Show quick mini-charts inside cells to visualize monthly sales trends for each product.

Sample Data

Product	Jan	Feb	Mar	Apr	May
Apples	120	135	150	160	170
Bananas	80	90	85	95	100
Cherries	60	70	75	80	85
Dates	40	45	50	55	60
Elderberries	30	35	40	45	50

Dashboard Components

• Sales Data Table: Shows product names and monthly sales numbers.
• Sparklines Column: Mini line charts in cells next to each product showing sales trend from Jan to May.
  Sparkline example for Apples in cell G2:
  Insert > Sparklines > Line (data range B2:F2, location range G2)
• Total Sales KPI: Sum of all sales for each product.
  Formula example for Apples in cell H2:
  =SUM(B2:F2)

Dashboard Layout

+-------------------------------+
| Product | Jan | Feb | ... | Sparkline | Total |
+----------------------------------------------+
| Apples  | 120 | 135 | ... |  (mini chart) | 735  |
| Bananas |  80 |  90 | ... |  (mini chart) | 450  |
| Cherries|  60 |  70 | ... |  (mini chart) | 370  |
| Dates   |  40 |  45 | ... |  (mini chart) | 250  |
| Elderb. |  30 |  35 | ... |  (mini chart) | 200  |
+----------------------------------------------+

Interactivity

Add a filter for product category or month to update the sparklines and total sales dynamically. For example, selecting only Jan to Mar updates the sparklines to show only those months and recalculates totals accordingly.

Self Check

If you add a filter to show only sales from Feb to Apr, which components update?

• The sparklines update to show only Feb, Mar, and Apr data.
• The total sales KPI recalculates sum for Feb to Apr only.
• The sales data table shows filtered months or highlights filtered data.

Key Result

Mini line charts (sparklines) show monthly sales trends per product alongside total sales.