Sparkline charts

Important: You can no longer use sparkline charts in Google Sheets. If you used a sparkline chart in the past, it might display as a line chart. In the future, use a line chart instead. Learn how to change the chart type.

 

Sparkline chart

How to format your data

  • First row (Optional): In the first row of each column, enter a category name. Entries in the first row show up as labels in the legend.
  • Columns: For each column, enter numeric data. You can also add a category name (optional). Each column shows up as a separate line in the chart.
  • Rows: Each row represents a different point in the line.

Example

Revenue & expenses
Month Expenses Revenue
January $100,000 $120,000
February $120,000 $135,000
March $110,000 $140,000
April $120,000 $145,000
May $125,000 $150,000
June $110,000 $140,000
July $95,000 $125,000
August $100,000 $130,000
September $100,000 $128,000
October $120,000 $147,000
November $130,000 $160,000
December $110,000 $145,000

 

Sparkline chart showing revenue and expenses

 

Make a copy

Customize a sparkline chart

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Double-click the chart you want to change.
  3. At the right, click Customize.
  4. Choose an option:
    • Chart style: Change the background color and font.
    • Sparkline: Change label position, fill, or show axis lines or values.
    • Chart & axis titles: Edit or format title text.
    • Series: Change line color or add min or max values.

Related articles

Was this helpful?
How can we improve it?