Arrow left
Back to guides
Google Sheets Formulas

How to create a Sparkline Chart in Google Sheets

When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always easy to create a chart into within the cell . However, using the SPARKLINE function you can create one-cell charts.

A Sparkline chart is a very small line chart that allows you to quickly visualize your data. It’s useful if you want to quickly see if the data in a spreadsheet was going up or down, for instance.

The SPARKLINE function in Google Sheets allows you to insert these types of charts into a single cell on your spreadsheet. it helps to create a bar, column, or win/loss chart, along with the typical line chart.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

1. Line sparkline chart:

This is the default for sparkline chart in Google Sheets, which means Google will default to showing a line if you don’t specify anything in your options.

=SPARKLINE(data-range)

  • data-range – the data range you want to create the sparkline for. The data range may vary depending on the chart type but must include more than two cells in a column or row.

2. Line, Column, Win/Loss, and Bar sparkline charts with color and linewidth:

=SPARKLINE(data, [options])

  • data-range – the data range you want to create the sparkline for. The data range must include more than two cells in a column or row.

  • option – the customization setting for the sparkline chart.

  • option-value – the value associated with the customization setting.

Notes:

  • colors can be written using their names (e.g. 'green') or as a hex code (e.g. '#5E5E5E').

  • To modify the color of a line chart, change the font color of the cell.

Turn Quickbooks Online data into a Google Sheets dashboard
100+ templates, update automatically, totally secure!
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

No items found.