When you’re working with large amounts of data in a Google Sheets spreadsheet, it isn’t always easy to create a chart within a 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.