How-to · Excel for Mac
How to insert a sparkline in Excel on Mac: step by step for Microsoft 365
To insert a sparkline in Excel on Mac, select your data, go to Insert > Sparklines, pick Line or Column, choose the output cell, and click OK. The same steps work in Excel for Microsoft 365, Excel 2024, and Excel 2021 for Mac, and the sparklines update when your data changes.
Quick answer
- Select your data, then go to Insert > Sparklines and pick Line or Column.
- The Insert Sparklines dialog fills in the data range for you. You only choose where the sparklines go.
- The output cells must match the shape of your data, or Excel shows an inconsistent-range error.
- Format sparklines on the Sparkline tab. Press Command+Z right away to undo a style you don't want.
- Community answers from 2022 and 2024 say Excel for the web can't create sparklines, so use desktop Excel.
What you need
- Excel for Mac: Microsoft 365, Excel 2024, or Excel 2021
- A range of numbers on the sheet to chart
- Desktop Excel, not Excel for the web
- A few minutes for your first sparkline
How to Insert a sparkline in Excel on Mac in Excel on a Mac
Select your data range
Click the first cell of the numbers you want to chart, then drag to the last cell. Include only the numbers. Leave out labels in the first column and the header row. The Mac article starts with this selection.
Tip: Microsoft's general guide starts from an empty cell at the end of a row instead. Either order reaches the same dialog.
Open the Insert tab
⌘⌥R
Click the Insert tab in the ribbon at the top of the Excel window. If the ribbon is hidden, press Command+Option+R to bring it back.
Tip: ⌘⌥R shows or hides the ribbon. Microsoft lists no shortcut that opens the Insert tab directly.
Choose Sparklines and a type
In the Sparklines group, click Line or Column. Line shows a trend, and Column draws each value as a bar. You can change the type later on the Sparkline tab if the look doesn't fit.
Tip: Win/Loss appears in the Sparkline tab's chart type control in Microsoft's general guide. Check your copy before you rely on it.
Check the data range in the dialog
The Insert Sparklines dialog opens. Its first box is already filled from your selection. Read it before you move on. It should list the same cells you selected.
Tip: If the box is wrong, click it and select the range again.
Pick the output cells
Click the second box in the dialog, the one that asks where the sparklines go. Then select the cell or range on the sheet for the sparklines. Keep the output shape matched to your data.
Tip: The output must match the shape of the data, or Excel shows an inconsistent-range error.
Click OK
Click OK. Excel draws the sparklines in the cells you chose. Each sparkline sits inside a single cell, so it fits beside your numbers.
Tip: If the result looks wrong, select a sparkline and check its data range on the Sparkline tab.
Check the result against your data
Look at each sparkline next to its row. Make sure it shows the trend you expect. Edit Data on the Sparkline tab lets you change the source range if something looks off.
Tip: Fix the source range first. Formatting is easier to judge once the data is right.
Which Excel for Mac versions can insert sparklines
Microsoft's Mac sparkline guide lists three versions: Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. If you use one of those, the steps on this page match your screen. Check your version before you start, so you don't search for a menu that isn't there.
- Excel for Microsoft 365 for Mac
- Excel 2024 for Mac
- Excel 2021 for Mac
Older copies need more care. Microsoft's general sparkline guide also names Excel 2019 and Excel 2016. The Mac article doesn't cover those versions, so the Mac steps may not match them exactly. If you're on an older copy, compare your Insert tab with the Mac article before you click anything.
Insert a sparkline in Excel on Mac, step by step
The steps on this page follow Microsoft's Mac article. You select the data, choose a sparkline type, confirm the data range, and pick the output cells. Excel does most of the typing once the dialog opens.
Choose Line, Column, or Win/Loss for your data
The type decides how the sparkline reads. A line shows direction over time, such as sales rising or falling across months. A column draws each value as a bar, so small differences stand out side by side. Win/Loss is for results that go up or down against a zero line.
| Type | Best for | Watch out for |
|---|---|---|
| Line | Direction over time, like monthly totals | A flat line can hide small changes, so check the axis options. |
| Column | Comparing each value in a row | Many bars can look crowded in a small cell. |
| Win/Loss | Results that are positive or negative | The general guide lists it on the Sparkline tab. Confirm it on your copy. |
Look at your data before you pick a type. If you're unsure, start with Line for trends. You can switch the chart type later on the Sparkline tab if the look doesn't fit.
Fix the inconsistent range error when you insert sparklines
The most common error is the inconsistent-range message. It shows up when the output cells don't match the shape of your data. Excel wants the output to line up with the source, row for row. A row of data needs output in the same row. Several rows need the same number of output rows.
- Count the rows in your data. Your output needs the same number of rows.
- For one row of data, place the sparkline in a single cell on that same row.
- Select the output cells before you click OK, and check the second box in the dialog.
- If the error still shows, reselect the data range in the dialog and try again.
Format markers, colors, and styles on the Sparkline tab
Select a sparkline and the Sparkline tab appears. Most formatting lives there. Start with markers. In the Show group, turn on markers for high and low points. Then use the Marker Color button to change their color.
The style gallery changes the look in one click. Sparkline Color changes the line color, and Weight changes the line width. If you pick a style you don't like, press Command+Z right away. That undoes the style immediately.
- Show group: turn markers on or off
- Marker Color: change the color of the markers
- Style gallery: pick a preset look
- Sparkline Color and Weight: change the line
- Axis: useful when your data has positive and negative values
Handle empty cells and zero values in sparklines
Empty cells and zeros can change how a line looks. Select the sparkline, go to the Sparkline tab, open the arrow next to Edit Data, and point to Hidden and Empty Cells. The Mac article covers this setting but doesn't say what each option does. Test one option on a small sample before you apply it to the whole sheet.
Update, edit, and remove sparklines
Sparklines update when the source data changes. You don't rebuild them after you edit a number. To remove one, select it, go to the Sparkline tab, open the arrow next to Clear, and choose Clear Selected Sparklines. Choose Clear Selected Sparkline Groups to remove a whole group.
Removing a sparkline doesn't remove your numbers. The source cells stay where they are. Check the sheet after you clear, so you know you removed the right group.
Mac keyboard shortcuts for sparkline work
Microsoft's Mac article documents one shortcut for this workflow. Command+Z undoes a style change right away. Microsoft's Mac shortcut list has no shortcut for sparklines, and none that opens the Insert tab. Two general shortcuts help when the ribbon is hard to reach.
Command+Option+R minimizes or maximizes the ribbon. F6 and Shift+F6 move focus between the worksheet, the ribbon, the task pane, and the status bar. Shift+F10 opens the context menu.
Excel for the web: why sparklines may not appear
Microsoft's browser comparison says sparklines display in a browser window. It documents viewing them, not creating them. Community answers from 2022 and 2024 say the Insert ribbon in Excel for the web doesn't offer sparklines.
A Microsoft Tech Community reply from August 2024 said sparklines appear in desktop Excel but not in Excel Online. The workaround is to open the file in desktop Excel. Create the sparklines there, then share the file for viewing.
Some tutorials mention a SPARKLINE formula for Excel for the web. I couldn't confirm it in Microsoft's pages. Don't rely on that formula for Excel on Mac. Use the Insert tab in desktop Excel instead.
Mistakes people make with sparklines on a Mac
- Selecting labels along with the numbers. Select only the cells you want to chart.
- Picking output cells with a different shape from the data, then getting the inconsistent-range error.
- Choosing a type before reading the data, so a line hides the small changes you care about.
- Looking for a sparkline shortcut. Microsoft's Mac list has none for this workflow.
- Trying to create sparklines in Excel for the web, which community answers say can't be done.
- Using an older Excel version the Mac article doesn't list, without a test copy first.
Worked example: a sparkline for each product row
Say each row holds one product, with its monthly sales in the cells to the right. The product name sits in the first column. Select only the monthly sales cells for one row. Go to Insert > Sparklines and choose Line.
In the dialog, leave the data range as Excel filled it. Click the empty cell at the end of that row for the location, then click OK. Drag the fill handle down to add the other product rows, as Microsoft's general guide describes.
2
community answers from 2022 and 2024 saying Excel for the web can't create sparklines
Sparklines missing from Insert ribbon (Microsoft Tech Community)When you change a monthly figure, the sparkline updates on its own. Your totals and sparklines stay in sync without a rebuild. That is the main reason to use sparklines in a summary sheet.
What to do after your sparklines look right
Sparklines work best beside a total or a headline number. If you need totals first, make a pivot table in Excel on Mac, then add sparklines to the summary. To pull values into one place, use XLOOKUP in Excel on Mac.
Excel shortcuts for this on Mac
| To do this | Press |
|---|---|
| Undo a sparkline style right away | ⌘Z |
| Minimize or maximize the ribbon | ⌘⌥R |
| Switch focus between worksheet, ribbon, task pane, status bar | F6 |
| Open the context menu | ⇧F10 |
| Move to the previous ribbon control | ⇧Tab |
If it does not work
- The Sparklines group is missing from the Insert tab
- Check that you're in desktop Excel, not the browser. Community answers from 2022 and 2024 say Excel for the web doesn't offer sparklines. Open the file in desktop Excel and try again.
- Excel shows an inconsistent-range error
- The output cells don't match the shape of your data. Match the number of rows, and place a row of data's sparkline on that same row. Then reselect the data range in the dialog.
- The Sparkline tab doesn't appear
- The Sparkline tab shows only when a sparkline is selected. Click the sparkline cell first, then check the ribbon again.
- A sparkline looks flat or has gaps
- Select the sparkline and open Edit Data on the Sparkline tab. Check the data range, then point to Hidden and Empty Cells and choose the option that fits your data.
- I changed a style and want it back
- Press Command+Z right after the change. Microsoft's Mac article says that undoes the style immediately.
Faster with Lazur
Do it faster: ask Lazur while you are in Excel
Hold ⌥ ⌘ and say what you want. Lazur sees your Excel window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Excel. Nothing to copy into a chat window.
Free for 3 days, then $18/month. Download for Mac
You say“Where's the Sparklines button?”
Lazur · points at itLazur circles the Sparklines group on the Insert tab and labels it, so you can find it without hunting.
Questions people ask
Can I insert a sparkline in Excel on Mac without the Insert tab?
Not in Microsoft's steps. The Sparklines group sits on the Insert tab. If the ribbon is hidden, press Command+Option+R to show it. Microsoft's Mac shortcut list has no sparkline shortcut.
Which Excel for Mac versions can insert sparklines?
Microsoft's Mac article lists Excel for Microsoft 365 for Mac, Excel 2024 for Mac, and Excel 2021 for Mac. The general guide also names Excel 2019 and 2016, but it doesn't cover Mac differences.
Why does Excel say the ranges are inconsistent?
The output cells don't match the shape of your data. Pick output cells with the same number of rows as your data, and the error should go away. Reselect the data range in the dialog if it still shows.
Do sparklines update when I change my numbers?
Yes. Microsoft's Mac article says sparklines update automatically when the source data changes. You don't need to rebuild them after you edit a value.
Can I create sparklines in Excel for the web on a Mac?
Community answers from 2022 and 2024 say no. Microsoft's browser comparison documents viewing sparklines, not creating them. Create them in desktop Excel, then open the file in the browser to view.
How do I change the color of the sparkline markers?
Select the sparkline and open the Sparkline tab. Turn on markers in the Show group first, so there is something to color. Then use the Marker Color button.
Is there a SPARKLINE formula for Excel on Mac?
I could not confirm one. A DataCamp tutorial mentions a SPARKLINE formula and says it also works in Google Sheets. Microsoft's pages don't document it for Excel on Mac, so use the Insert tab instead.
How do I delete a sparkline without deleting my data?
Select the sparkline, go to the Sparkline tab, open the arrow next to Clear, and choose Clear Selected Sparklines. Your source numbers stay in their cells.
Sources
- Create sparklines in Excel for Mac · Microsoft Support · checked 2026-11-09
- Use sparklines to show data trends · Microsoft Support · checked 2026-11-09
- Differences between using a workbook in the browser and in Excel · Microsoft Support · checked 2026-11-09
- Keyboard shortcuts in Excel · Microsoft Support · checked 2026-11-09
- Sparklines missing from Insert ribbon · Microsoft Tech Community · checked 2026-11-09
- Excel Sparklines: A Complete Guide · DataCamp · checked 2026-11-09
Try Lazur free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.