The SPARKLINE function lets a spreadsheet user embed a miniature chart into a cell. Sparklines are similar to regular charts but much simpler to use. Sparklines can be in the form of bar charts, column, and win-loss, or line graphs.

## Syntax

`=SPARKLINE(data,[options])`

`data`

– The range of cells or array of data from which to make the sparkline.`[options]`

– Optional specifications to customize the chart. There are many options.

## Video Explanation

## Examples

As shown in the image below, sparklines can produce a visual for one row at a time. While this data would be noisy in a full chart, sparklines allow you to see each row clearly without other distracting data.

The first chart is a line chart that can help show trends. The bar chart shows the proportion of amounts relative to a whole. Column charts can show individual numbers’ values, and a win-loss chart shows whether each value is positive or negative.

### Live Examples in Sheets

Go to this spreadsheet for more examples you can study and use anywhere.

## 1 thought on “SPARKLINE Function – Google Sheets”