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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. Treat “add sparklines in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. 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. That turns a visual that makes the number obvious at a glance into a method you can reuse, explain, and defend when the workbook leaves your screen.
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 there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
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. Here is the takeaway for “add sparklines in excel”: copy the answer if you are busy, but if you have a spare few minutes, rebuild the example in Excel yourself with the tool above open beside it. That single pass — type it, run it, watch the result move when you change an input — is what turns a formula you found into a technique you trust. Keep your inputs labelled and referenced, never hard-coded, and the same sheet stays correct and auditable as it grows. Done that way, you will not need to look this up again, and you will be the person others ask.
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.
Other ways people ask this
This is also commonly searched as “how to add a sparkline in excel” and “add sparklines in excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
This guide also answers
- how to insert sparklines in excel
- inserting sparklines in excel
Why do people search for this in so many different ways?
Because the same task has many names. “how to add a sparkline in excel”, “add sparklines in excel” all point at the one operation explained on this page, which is why they all lead here.