A sparkline is a tiny chart that lives inside a single cell — perfect for showing a trend right next to the numbers. Three flavors: line, column, and win/loss.
The example
Monthly sales with a trend sparkline beside each region.
| A | B | |
|---|---|---|
| 1 | Region | Trend |
| 2 | East | ▁▃▅▇▆█ |
| 3 | West | █▆▄▃▁▂ |
The formula
Sparklines are inserted, not typed — here’s the menu path:
How it works
Sparklines summarize a row of numbers in one cell:
- Select where the sparkline should go, then Insert → Sparklines and pick Line, Column, or Win/Loss.
- Set the Data Range (the row of values) and the Location (the sparkline cell).
- Use the Sparkline ribbon tab to show the high/low points, mark the last point, or set a color.
- Drag the fill handle down to give every row its own sparkline from its own data.
Make them comparable: by default each sparkline scales to its own data. On the Sparkline tab, set the vertical axis Min/Max to the same fixed values across the group so trends are visually comparable row to row.
Try it: interactive demo
Enter values; see a line sparkline.
Variations
Column sparkline
Bars instead of a line:
Win/Loss
Up/down blocks for +/− values:
Highlight high & low
Sparkline tab → check High Point, Low Point.
Pitfalls & errors
Independent scaling by default. Each sparkline auto-scales, so two that look similar may have very different ranges. Fix the axis Min/Max to compare.
Sparklines aren’t cell values. They’re a layer on top of the cell — you can still type in the cell, and copying the cell carries the sparkline.
2010 or later. Sparklines don’t exist in Excel 2007; the cell shows blank there.
Practice workbook
Frequently asked questions
How do I add a sparkline in Excel?
How do I make sparklines comparable across rows?
Why don't my sparklines appear?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class