Excel Sparklines: Tiny Trend Charts Inside Cells

A table of 12 monthly numbers per branch is hard to read. A sparkline — a tiny chart inside a cell — shows each row’s trend at a glance.

Insert sparklines

1. Select the empty column next to your data (one cell per row).
2. Insert → Sparklines → Line, Column or Win/Loss.
3. Data Range: the monthly numbers (e.g. B2:M20); Location: the empty column. OK.

Make them useful

• Markers: Sparkline tab → tick High Point and Low Point, and give them distinct colours.
• Same axis for all rows: Sparkline → Axis → Vertical axis minimum and maximum → “Same for all sparklines”. Without this, a branch with tiny sales looks as dramatic as the biggest one.
• Win/Loss for signs only: months above or below target (use a helper range of actual − target).
• Make the row taller and the column wider — sparklines scale with the cell.

Gaps and hidden data

Sparkline → Edit Data → Hidden & Empty Cells: choose whether blanks show as gaps or zero, and whether data in hidden columns is included.

In dashboards

Pair a big current-month number with a sparkline of the last 12 months underneath — the reader gets both the value and the trend.

See also waterfall charts.