In Excel: select the empty cells that should hold them, then Insert ▸ Sparklines ▸ Line, pick the data range, and confirm — one mini chart is drawn inside each cell.
On this page7
Select the empty cells that will hold the sparklines — one per data row, usually the column to the right of the data.
Insert ▸ Sparklines ▸ Line (or Column, or Win/Loss).
Set Data Range to the number range, leave Location Range as the cells you selected, and confirm.
On the Sparkline tab, tick High Point and Low Point under Show to mark the extremes.
Sparkline ▸ Axis ▸ Vertical Axis Minimum/Maximum ▸ Same for All Sparklines makes rows comparable to each other.
To remove them: select the cells and use Sparkline ▸ Group ▸ Clear — the Delete key does not remove a sparkline.
What this does
A sparkline is a chart that lives inside a single cell rather than floating above the sheet. It has no axes, no legend and no title: it shows the shape of one row of numbers next to that row, which is exactly what a summary table needs and what a full chart is too heavy for. Three types exist — Line, Column and Win/Loss — and they are cell contents in the formatting sense, so they fill down like a formula, resize with the row, and print with the sheet. Because they are not shapes, the Delete key does nothing to them; they are removed from the Sparkline tab with Clear. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “use sparklines in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the outcome you expected before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a visual that makes the number obvious at a glance, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
A table has monthly revenue in B2:M13, one product per row. Select N2:N13, choose Insert ▸ Sparklines ▸ Line, set the data range to B2:M13, and each product gets a twelve-month trend line in its own row. Then open Sparkline ▸ Show ▸ Markers to mark High Point and Low Point, and set Sparkline ▸ Axis ▸ Same for All Sparklines so every row shares one scale — without that, a product ranging from 2 to 5 looks as volatile as one ranging from 200 to 5,000. A sparkline column turns a table of numbers into something a reader can scan in one pass, at a fraction of the space and maintenance cost of a chart per row — and it stays correct when rows are added, because it fills down like any other cell content. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. The short version of “use sparklines in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.
Common mistakes
- Leaving each sparkline on its own automatic scale, which makes rows look comparable when they are not — the single most common way a sparkline table misleads.
- Pressing Delete to remove one and concluding it is stuck; use the Clear button on the Sparkline tab.
- Putting sparklines in a merged cell — the group will not draw correctly and cannot be filled down.
- Expecting blanks and text to be skipped: empty cells break the line by default unless Sparkline ▸ Edit Data ▸ Hidden & Empty Cells is set to connect them.
- Reaching for a sparkline where the reader needs values — it shows shape only, so pair it with the number it summarises.
Frequently asked questions
How do I insert line sparklines in Excel?
Select the destination cells, then Insert ▸ Sparklines ▸ Line, set the data range and confirm. One mini line chart is drawn per row, inside the cell.
What is the difference between a sparkline and a line chart?
A sparkline sits inside one cell, has no axes or legend, and belongs to the cell like formatting. A line chart is a floating object with axes, titles and its own layout. Sparklines are for a column of trends beside a table; charts are for one story on its own.
Why will my sparkline not delete?
Sparklines are not shapes, so Delete ignores them. Select the cells and use Sparkline ▸ Group ▸ Clear Selected Sparklines.
Can sparklines share one scale?
Yes — Sparkline ▸ Axis, then set both Vertical Axis Minimum and Maximum to "Same for All Sparklines". Do this whenever the rows are meant to be compared with each other.