5.2 Sparklines and compact comparisons
Checked against Microsoft's Excel for Windows keyboard references, August 2026
What you'll be able to do
Show a trend beside every row of a table. Twenty products, twenty tiny trends, without building twenty charts. Know when a grid of small charts beats one crowded chart.
Before you start
Carry on in the dashboard starter workbook. Its sheet of months by product is built for this.
The work
- No documented keyboard shortcut for this — use the menu: select the empty column beside the table. Go to Insert → Sparklines → Line, set the Data Range to the month columns, and press Enter. A tiny trend appears in each row's cell. It is a chart that sits where the reader's eye already is, beside the number it explains.
- Same either way: pick the kind that fits the data. Line shows a trend. Column shows the size in each period. Win/loss shows only whether each period was above or below zero, which suits profitable months or targets met. All three come from the same Insert group.
- No documented keyboard shortcut for this — use the menu: mark the points that matter. With the sparklines selected, the Sparkline tab offers tick-boxes for High Point, Low Point and Last Point. The high point and the last point are usually the two worth marking.
- No documented keyboard shortcut for this — use the menu: here is the honesty setting almost everyone misses. Each sparkline is scaled to its own row to begin with, so a flat product and a doubling product can look identical. On the Sparkline tab, open Axis → set Minimum and Maximum to Same for All Sparklines. Rows meant to be compared need one shared scale. Without it, the column decorates instead of informing.
- Same either way: a formula does a rough version of the same thing.
=REPT("|", ROUND(B2/1000, 0))repeats one character per thousand, which gives in-cell bars with no chart machinery, and is handy in a plain report. Data bars from conditional formatting do the same job more neatly. - Same either way: the design rule behind the feature is called small multiples. Many small charts, all on identical scales, beat one chart carrying twelve tangled lines. When your line chart is a tangle, split it up: one small chart per line, the same axes on each, arranged in a grid. Sparklines are the smallest multiples there are, and the idea scales up to real grids of charts on a dashboard.
Try it
Add line sparklines to the monthly sheet and mark the high and last points. Then set the shared axis, and watch two rows that looked alike become honestly different. Add a REPT bar column beside a totals column. Find one tangled chart in the workbook and split it into small multiples.
Check yourself
What does a sparkline do that a normal chart cannot?
It lives in the row it describes. The trend sits beside the name and the number, in the reader's existing path across the page, one per row for a whole table.
Why is the starting per-row scaling a trap, and what is the fix?
Each sparkline stretches to fill its own cell, so very different sizes look alike. Set the axis Minimum and Maximum to Same for All Sparklines whenever the rows are meant to be compared.
Which kind of sparkline for "months where profit was above zero"?
Win/loss, because it shows only above or below, which is exactly the question. Line shows the trend, and column shows the size in each period.
When do small multiples beat one combined chart?
When one chart holds so many lines that they tangle. A grid of small charts on identical scales lets the eye compare shapes without untangling colours.
Go deeper
We haven't checked most of these for screen reader use yet.
Back to Sparklines and compact comparisons: work through the checklist