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.