Skip to content
AnIntent

Google Sheets Sparkline Charts Are Retired: What Google Confirms

Google has retired the Sparkline chart type in Sheets. Here is what Google confirms, what happens to old charts, and what to use instead.

AnIntent Editorial · · 2 min read

a person holding a piece of paper over a laptop
Photo by Jakub Żerdzicki on Unsplash
In this article
  1. What Google's help page says about Sparkline charts
  2. The chart type and the SPARKLINE formula are two different things
  3. If an old sparkline chart now looks different
  4. Where to look for formula examples
Share this article

If you searched for sparklines in Google Sheets, start here: according to Google's official Sparkline charts help page, you can no longer use sparkline charts in Google Sheets. Google tells readers to use a line chart instead.

This article covers what Google confirms about that change and what remains unconfirmed. It is shorter than a normal tutorial on purpose. The official syntax for the in-cell SPARKLINE formula could not be verified for this piece, so you won't find formula options here that might be out of date.

What Google's help page says about Sparkline charts

The Sparkline charts page carries an "Important" note with three points:

  • You can no longer use sparkline charts in Google Sheets.
  • Sparkline charts you made before may display as line charts.
  • Google recommends using a line chart instead.

The chart type and the SPARKLINE formula are two different things

This is where most of the confusion comes from. Sheets had two ways to make a sparkline:

  1. The sparkline chart type covered by Google's Sparkline charts help page. This is the one Google has retired.
  2. The SPARKLINE function, a formula that draws a mini-chart inside a single cell.

The retired chart type's help page still lists "SPARKLINE function" under its related articles. That suggests the function has its own documentation. If you rely on in-cell sparklines, follow that related-articles link from Google's page and check the function's documentation yourself before building anything around it.

If an old sparkline chart now looks different

If a sheet you built earlier has a sparkline chart that now looks like a regular line chart, that matches what Google describes: old sparkline charts may display as line charts. Nothing in your data is wrong. The chart type itself is gone.

The customization steps on Google's page were written for the retired chart type, so they may not match what you see in the chart editor now.

Where to look for formula examples

Several third-party guides cover SPARKLINE formulas, including ones from Ben Collins, Infoinspired and Coupler.io. Those pages weren't checked for this article, so compare anything you find there with Google's own documentation and test it in a copy of your sheet before you use it on real data.

Common questions

Can I still insert a sparkline chart in Google Sheets?

No. Google's Sparkline charts help page says you can no longer use sparkline charts in Google Sheets and recommends a line chart instead.

What happens to sparkline charts I already made?

According to Google's help page, they may display as line charts.

Is the SPARKLINE formula gone too?

Google's Sparkline charts page lists the SPARKLINE function as a separate related article. Check that documentation and test the formula in a copy of your sheet before relying on it.

Person working on a laptop with a spreadsheet outdoors
How-to

How to Lock Only Some Cells in Excel (Unlock Inputs, Then Protect)

Unlock the input cells, lock the formula cells, then protect the sheet so others can type in Excel without breaking your formulas.

· 4 min

Keep reading