SPARKLINE Function – Google Sheets

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.

Help for the SPARKLINE function

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

YouTube player

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.

Examples of the line, bar, column and win loss SPARKLINE charts
SPARKLINE Examples

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.