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. 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. For “insert line sparklines in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. 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 is what makes a visual that makes the number obvious at a glance useful in real work: repeatable, auditable, and not dependent on memory or luck.
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. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “insert line sparklines in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
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 do you insert line sparklines in excel” and “how to insert a line sparkline in excel”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “how do you insert line sparklines in excel”, “how to insert a line sparkline in excel” all point at the one operation explained on this page, which is why they all lead here.