
π This article includes 1 downloadable practice file β
Sometimes a full chart is too much: you want the trend next to each row of a table. Sparklines are tiny charts inside a cell.
Add sparklines
- Transpose the regions so each region is a row with 12 months (or select columns B:E per region).
- Select the empty cells next to the rows βΊ Insert βΊ Sparklines βΊ Line βΊ Data range: the monthly values.
- Sparkline tab: tick High Point and Low Point, choose a colour.
Types: Line (trend), Column (size per period), Win/Loss (positive vs negative, e.g. variance to target).
Data bars and REPT
Conditional Formatting βΊ Data Bars adds a bar behind each number. Or a text bar with a formula: =REPT("β", B2/MAX($B$2:$B$7)*20). More in in-cell bar charts with REPT.
Where people go wrong
| Problem | Fix |
|---|---|
| Sparklines not comparable | Same axis for all |
| Too small to see | Widen the column, increase row height |
| Deleted with Delete key | Use Sparkline βΊ Clear |
Practice
Add line sparklines with high/low points for each region, and data bars on the Products sales column.
π Practice files for this article
- πCharts practice dataMonthly regional sales, target, online share and product data.β¬ XLSX Β· 7 KB
Free to use for learning. Files with macros (.bas) are plain text β import them with Alt+F11 β File β Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.