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.
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. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “line sparkline excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above 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. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. If you take one thing from this page on “line sparkline excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
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.