Can SPARKLINE update automatically when new data is added?

Yes. SPARKLINE recalculates instantly when source cells change. Use dynamic ranges with FILTER or QUERY: =SPARKLINE(QUERY(data,"select score where student='Alice'")) refreshes whenever the source data updates.

What chart types can SPARKLINE display?

Four types: line (default smooth curve), column (vertical bars), bar (horizontal bars), and winloss (displays positive/negative values as up/down spikes). Select via {"chartType","column"} in options.

How do I compare multiple students' grades with sparklines in one row?

Create separate SPARKLINE formulas in adjacent cells, each pulling a different student's data. Example: cell A has Alice's sparkline =SPARKLINE(QUERY(...student='Alice')), cell B has Bob's =SPARKLINE(QUERY(...student='Bob')).

Is SPARKLINE available in Microsoft Excel?

No. SPARKLINE is exclusive to Google Sheets. Excel has a built-in Sparklines feature (Insert > Sparklines), but it uses a different, non-formula interface.

SPARKLINE function

SPARKLINE displays a miniature chart within a cell to visualize data trends and patterns without taking up extra space.

=SPARKLINE(data, [options])

Generate a SPARKLINE formula

Describe what you need. The generator will reach for SPARKLINE where SPARKLINE is the right tool, and tell you when it is not.

Arguments

How SPARKLINE reads its arguments

Argument	Required	Description
data	Required	Required. A single-row or single-column range or array of numeric values; empty or non-numeric data produces #N/A.
options	Optional	Optional. An object specifying visual settings such as chartType, color1, max, and min; defaults to a line chart if omitted.

Returns

An in-cell chart visualization (sparkline) showing the data trend; not a numeric value.

Availability

Excel: Not available · Google Sheets: Supported

Worked examples

1. Show a student's quiz score progression

Student	Subject	Assignment	Score	Max Score
Alice	Math	Quiz 1	85	100
Alice	Math	Quiz 2	92	100
Alice	Math	Quiz 3	88	100
Bob	Math	Quiz 1	78	100

=SPARKLINE(D2:D4)

Result: A line chart sparkline with three points (85, 92, 88) showing an upward peak at the middle value

SPARKLINE renders cells D2:D4—Alice's three Math quiz scores—as a tiny in-cell line chart. The visual peaks at 92, making the performance pattern instantly visible without leaving the spreadsheet.

2. Visualize percentage scores across assignments

Student	Subject	Assignment	Score	Max Score
Alice	Math	Quiz 1	85	100
Alice	Math	Quiz 2	92	100
Alice	Math	Quiz 3	88	100

=SPARKLINE(ARRAYFORMULA(D2:D4/E2:E4))

Result: A line chart sparkline showing three normalized points (0.85, 0.92, 0.88) representing percentages

By dividing Score by Max Score, we convert raw grades to proportions. SPARKLINE visualizes these normalized values, allowing fair comparison even when quizzes had different point totals or difficulty levels.

3. Create a red column chart scaled to 100

Student	Subject	Assignment	Score	Max Score
Alice	Math	Quiz 1	85	100
Alice	Math	Quiz 2	92	100
Alice	Math	Quiz 3	88	100

=SPARKLINE(D2:D4,{"chartType","column";"color1","#EA4335";"max",100})

Result: A column chart sparkline with red bars at heights 85, 92, and 88 on a 0–100 scale

The options parameter overrides defaults: chartType renders vertical columns instead of a line, color1 paints them red, and max sets the scale ceiling at 100. This emphasizes individual values and makes it easy to judge scores against the perfect maximum.

Common errors

Which SPARKLINE error are you seeing?

Error	Why it happens	How to fix it
#N/A	The data array is empty or contains errors (like #DIV/0!) that SPARKLINE cannot render as a chart.	Ensure all cells in the range contain valid numeric data. Use IFERROR to exclude error values: =SPARKLINE(IFERROR(D2:D4,""))
#VALUE!	The options parameter has syntax errors, such as missing semicolons between key-value pairs, misquoted keys, or invalid setting names.	Review options carefully. Use this syntax: {"key1","value1";"key2","value2"}. Check that all keys are recognized: chartType, color1, color2, min, max, etc.
#REF!	The data range references cells that have been deleted, moved to another sheet, or no longer exist.	Update the formula to reference valid cells, or use IFERROR to handle missing references gracefully: =IFERROR(SPARKLINE(D2:D4),"–")

Tips and when to use something else

SPARKLINE shines with 3–50 data points. For 100+ points or when you need legends, axis labels, and interactivity, use CHART() instead.
Pair SPARKLINE with FILTER() to create dynamic in-cell charts: =SPARKLINE(FILTER(scores, student='Charlie')) updates when the data changes.
To apply consistent formatting across many sparklines, define options in a helper cell and reference it, avoiding manual repetition.
Wrap SPARKLINE in IFERROR when data might be incomplete: =IFERROR(SPARKLINE(D2:D4),"–") displays a dash if data is missing.

Related functions

FILTERReturns filtered rows from an array based on a boolean criteria array, retaining the original order and all columns.QUERYQuery a dataset using SQL-like syntax to filter, sort, and extract specific rows and columns that match your conditions.INDEXINDEX returns the value or array of values from a specified position within a given range, based on row and optional column numbers.ARRAYFORMULAARRAYFORMULA applies a single formula to an entire array or range, automatically filling results into multiple cells.

Frequently asked questions

Can SPARKLINE update automatically when new data is added?: Yes. SPARKLINE recalculates instantly when source cells change. Use dynamic ranges with FILTER or QUERY: =SPARKLINE(QUERY(data,"select score where student='Alice'")) refreshes whenever the source data updates.
What chart types can SPARKLINE display?: Four types: line (default smooth curve), column (vertical bars), bar (horizontal bars), and winloss (displays positive/negative values as up/down spikes). Select via {"chartType","column"} in options.
How do I compare multiple students' grades with sparklines in one row?: Create separate SPARKLINE formulas in adjacent cells, each pulling a different student's data. Example: cell A has Alice's sparkline =SPARKLINE(QUERY(...student='Alice')), cell B has Bob's =SPARKLINE(QUERY(...student='Bob')).
Is SPARKLINE available in Microsoft Excel?: No. SPARKLINE is exclusive to Google Sheets. Excel has a built-in Sparklines feature (Insert > Sparklines), but it uses a different, non-formula interface.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17