What is SPARKLINE in Google Sheets?
SPARKLINE draws a miniature chart inside one cell from a row or column of numbers. Choose line, column, bar, or winloss types and pass an options object for color, axis, and markers. Dashboard tables use sparklines to show trend without full charts.
When to use it
Use SPARKLINE in scorecards where each row needs a quick trend: weekly sales, test pass rates, or inventory levels beside the current number.
When to skip it
Skip SPARKLINE when stakeholders need labeled axes, legends, or export-quality graphics. Build a normal chart on a dashboard tab instead.
How it works
-
1
Select a numeric range, usually one row or column of values in chronological order.
-
2
Enter =SPARKLINE(B2:M2) for a default line sparkline across twelve months.
-
3
Add a second argument with charttype and color options in JSON-like syntax.
-
4
Use "winloss" for binary outcomes and "column" for discrete period comparisons.
-
5
Keep source cells as numbers, not text dates disguised as numbers, for consistent scaling.
-
6
Adjust column width so the sparkline is visible but does not dominate the row.
Examples in Google Sheets
Monthly sales trend
=SPARKLINE(D2:O2, {"charttype","line";"color","#34a853"}) shows a green line beside each rep totals.
Win-loss streak
=SPARKLINE(results_row, {"charttype","winloss";"poscolor","green";"negcolor","red"}) marks W and L games.
Column micro chart
=SPARKLINE(B2:F2, {"charttype","column";"ymin",0}) compares five weekdays in one cell.
Better Sheets resources
Common mistakes
-
Including blank text cells in the range, which breaks scaling or shows flat lines.
-
Using sparklines where full charts are required for executive reviews.
-
Forgetting ymin and ymax when small changes look flat on large absolute values.
-
Embedding sparklines in narrow columns so the graphic is invisible.
-
Pointing at a range that grows without updating the formula reference.
Frequently asked questions
- Can SPARKLINE use multiple rows?
- Typically one row or column per sparkline. Use separate formulas per row in a table.
- SPARKLINE colors?
- Pass color, negcolor, and poscolor in the options argument.
- Why is my sparkline flat?
- Values may be identical, text not numbers, or ymin/ymax hide variation.
- SPARKLINE vs chart?
- Sparklines are in-cell thumbnails. Charts are separate objects with axes and labels.
- Can SPARKLINE show markers?
- Some line options support markers. Check current SPARKLINE options documentation.
- SPARKLINE with negative numbers?
- Line and column types handle negatives. Winloss expects binary wins and losses.
- Copy sparklines down?
- Drag the formula so each row points at its own numeric range.
Related Tutorials
Watch how SPARKLINE works
Add Cool Responsive Graphs to Your Stock Tracking Sheets
Create a Progress Bar - Make Progress Bars with Sparkline: Part 1
Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4
10 Things I Hate About Your Spreadsheets
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
3 Free Tools to Make Your Google Sheets Better
Related blog posts
Guides that explain SPARKLINE in more depth.
How to Say "I Do Google Sheets"
We do spreadsheets. That's what we do. We use Google Sheets for everything. So how on earth are we to get across all of the nuance and power that we hold at our finger tips?
Read post →Spreadsheets Explained over 5 Levels of Difficulty
Master Google Sheets from simple text input to complex operations with our FREE tutorials, templates, and tools! Unleash the full power of spreadsheets now!
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →Related terms
GOOGLEFINANCE
GOOGLEFINANCE connects your sheet to Google market data. Pass a ticker symbol, an attribute like price or volume, and optional date range arguments for historical quotes. Portfolio trackers and FX dashboards use it to avoid manual price copy-paste.
Read guide →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same height as the data. FILTER spills results automatically, so it replaced many INDEX/SMALL helper-column patterns for live subsets.
Read guide →UNIQUE
UNIQUE extracts a deduplicated list from a column or table. Optional arguments control whether duplicates appear by row, by column, or with occurrence counts. It powers dropdown source lists, category tabs, and data cleanup without manual copy-paste.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →Done reading about SPARKLINE?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.