Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SPARKLINE
SPARKLINE creates a small inline chart — line, bar, column, or winloss — inside a single cell, providing at-a-glance visual trends without taking up chart space. It accepts an optional options object to control chart type, colors, min/max axes, and more. Ideal for dashboards where compact visual summaries matter.
Excel
=SPARKLINE(B2:E2,{"charttype","column";"color","blue"})Google Sheets
=SPARKLINE(B2:E2,{"charttype","column";"color","blue"})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
How it works
- 1Select the data range for the sparkline (e.g., B2:E2 for a row of values).
- 2Optionally pass an options array as the second argument using curly braces: {"charttype","line";"color","green"}.
- 3Place the formula in the cell where you want the miniature chart to appear — resize the cell for a better view.