To add a sparkline in Excel, select a blank cell next to your data, then on the Insert tab, in the Sparklines group, choose Line, Column, or Win/Loss. In the Create Sparklines dialog, enter the Data Range that holds the numbers, for example B2:E2, confirm the Location Range is the cell you selected, and select OK. Excel draws a tiny chart inside that one cell that reads the row of values.
A sparkline is a mini chart in the background of a single cell, so it summarizes a run of numbers right where you can see them, without building a full chart object. The cell keeps no value of its own from the sparkline, which is the first thing to get straight about them, and the choice between Line, Column, and Win/Loss decides what the little chart actually tells you.
How do I insert a sparkline?
Pick the cell where the chart should sit first, usually the blank cell at the end of the row it summarizes, since a sparkline reads best next to its data. Then on the Insert tab, in the Sparklines group, choose the type you want, and fill in the Create Sparklines dialog: the Data Range is the block of numbers to chart, and the Location Range is the cell (or cells) that will hold the sparklines. If your figures are in cells B through E of row 2, the Data Range is B2:E2. Select OK and the chart appears.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Region | Q1 | Q2 | Q3 | Q4 | Trend |
| 2 | East | 120 | 90 | 140 | 110 |
To repeat a sparkline down a table, select the one you made and drag its fill handle, or use Fill Down (Ctrl+D), the same way you copy a formula. When the numbers in the Data Range change, the sparkline redraws on its own to match, because it is a live picture of that range rather than a snapshot.
The Microsoft page that documents this route, “Analyze trends in data using sparklines,” lists Excel for Microsoft 365, 2024, 2021, 2019, and 2016; on a Mac the dialog is named Insert Sparklines but the Data-Range-then-location flow is the same.
What is the difference between Line, Column, and Win/Loss?
The three types read the same numbers but draw them differently, and mixing up the last two is the usual mistake.
- Line connects the values into a small line, so the shape shows the trend across the range. Turn on the axis when the data crosses zero and the line will sit above and below it.
- Column draws one bar per value, each sized to its magnitude, so a larger number gives a taller bar and a negative number a bar below the line. This is the type for comparing how big the values are.
- Win/Loss ignores magnitude altogether. It shows each value as an equal-size marker by its sign only: up for a positive value, down for a negative value, and a gap for zero. Every up marker is the same height as every other, so it reads as a run of wins and losses rather than amounts.
That last contrast is the one to hold onto. Feed the row 9, then -2, then 14, then -1 to a Column sparkline and you get a tall bar, a short bar below the line, a taller bar, and a small one below, all sized to the numbers. Feed the same row to a Win/Loss sparkline and you get up, down, up, down, every marker identical, because 9 and 14 are both just positive. Column answers how much; Win/Loss answers only which way.
For the cell-filling cousin of these in-cell visuals, conditional formatting adds data bars and color scales, which shade or fill the cell itself based on its value rather than charting a range of neighboring cells.
Is a sparkline a value in the cell?
No, and this is what sets a sparkline apart from a formula result. The chart is painted in the background of the cell, so the cell carries no value from it. You can click into that cell and type text, and the text sits on top of the sparkline as a label, which is why people drop a region name or a total right over the chart. Because the sparkline is not a value, no formula can read it, and the ordinary Delete-key route for clearing a cell does not remove it. Removing one has its own command, below.
How do I format or change a sparkline?
Select a sparkline and Excel shows the contextual Sparkline tab (named Sparkline Design on a Mac). Everything you change there applies to the sparkline you selected, and to the rest of its group with it. From that tab you can:
- Switch the Type between Line, Column, and Win/Loss at any time, so a chart you drew as a line becomes columns without starting over.
- Turn on markers in the Show group, check boxes for the High Point, Low Point, First Point, Last Point, and Negative Points, plus Markers to dot every value on a Line sparkline. Recolor them with Marker Color.
- Restyle with the Style gallery and Sparkline Color.
- Set the Axis. Show Axis draws a horizontal zero line, which helps a Line sparkline that crosses zero, and the vertical options let each sparkline scale to its own high and low, or share one scale across the whole group, or take a value you set.
Sparklines you create together in one action form a group, and formatting them is an all-at-once affair: a change on the Sparkline tab lands on every sparkline in the group. When you want to style or retype just one, choose Ungroup first to break the set apart, then work on the single chart on its own.
How do I remove a sparkline?
Select the cell and choose Clear on the Sparkline tab; the arrow beside Clear lets you clear the one sparkline or the entire group. Pressing the Delete key does not take it off, because the chart lives in the cell background rather than as the cell’s value. Delete clears any label text you typed over the sparkline and leaves the chart in place, which is a common source of confusion, so reach for Clear instead.
One more setting to check before you rely on a sparkline: by default it leaves out data sitting in hidden rows or columns. If you have filtered or hidden part of the source and want it counted anyway, select the sparkline, open the Hidden and Empty Cells dialog from the Sparkline tab, and turn on Show data in hidden rows and columns. The same dialog decides how empty cells read, as Gaps, as Zero, or connected across with a line.
The short version
- Insert: select a blank cell, then Insert > Sparklines > Line, Column, or Win/Loss, and set the Data Range and Location Range in the Create Sparklines dialog.
- Three types: Line shows the trend, Column sizes each bar to its magnitude, and Win/Loss shows an equal-size marker by sign only (up for positive, down for negative, gap for zero) and ignores magnitude.
- Not a value: a sparkline is a chart in the cell background, not the cell’s contents, so you can type a label over it and no formula reads it.
- Format: on the Sparkline tab, add markers (High Point, Low Point, and the rest of the Show group), a Style, Marker Color, or an Axis; sparklines made together are a group, so Ungroup to change one alone.
- Remove with Clear: choose Clear on the Sparkline tab, not the Delete key, which only clears text over the chart. By default sparklines skip data in hidden rows and columns unless you turn that on in Hidden and Empty Cells.
- See also: conditional formatting fills the cell itself with data bars and color scales, the in-cell cousin of a sparkline.
