Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to create a sparkline in Excel and Google Sheets
Excel & Google Sheets
=SPARKLINE(B2:B6)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the cell where you want the sparkline to appear.
- 2In Excel, go to the Insert tab and click on Sparkline. Choose the type of sparkline you want (Line, Column, Win/Loss). In Google Sheets, enter the SPARKLINE formula directly into the cell.
- 3For Excel, select the range of data you want to include in the sparkline. For Google Sheets, specify the range within the SPARKLINE formula.
- 4Adjust any additional settings such as colors or markers if needed.
- 5Click OK in Excel to insert the sparkline. In Google Sheets, press Enter to display the sparkline.
Tips
- Ensure your data range does not contain text or non-numeric values to avoid errors.
- Customize the appearance of your sparkline by right-clicking it in Excel or using the options in the SPARKLINE function in Google Sheets.
- Remember that sparklines are best used with small datasets to maintain clarity.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I change the color of the sparkline?
Yes, in Excel, right-click the sparkline and choose Format Sparkline. In Google Sheets, use the color parameters within the SPARKLINE function.
What types of data are suitable for sparklines?
Sparklines are ideal for showing trends over time or comparing values across categories in a compact format.
How do I remove a sparkline?
In Excel, right-click the sparkline and select Delete Sparkline. In Google Sheets, simply delete the cell containing the SPARKLINE formula.