Arrow left
Back to product 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.

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.

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

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711