SPARKLINE Function in Google Sheets

Create a mini-chart within a cell using the SPARKLINE function.

SPARKLINE Function

The SPARKLINE function in Google Sheets is used to create a mini-chart within a cell to visually represent data.

Syntax

SPARKLINE(data, [options])
  • data: The range or array of data to visualize. This is a required parameter.
  • options: (Optional) A range or array of optional settings to customize the chart.

Example

  1. Basic Sparkline

Create a line sparkline for the data range A1:A10:

=SPARKLINE(A1:A10)

This will display a line chart within the cell.

Notes

  • The function supports multiple types of sparklines, including line, bar, and column charts.
  • GOOGLEFINANCE: Use financial data with sparklines for stock price visualization.