See all How-To Articles

Insert Line / Column Sparklines in Excel & Google Sheets

This tutorial demonstrates how to insert sparklines in Excel and Google Sheets.

 

Sparklines Intro

 

What Are Sparklines?

Sparklines are small graphs that are contained within one cell. They are often placed near relevant data to optimize the amount of space taken up. Data that a sparkline uses is organized in the same way as data would be organized in a regular chart. You can have Line, Column, or Win/Loss Sparklines.

Line Sparkline

  1. In the Ribbon, select Insert > Sparklines > Line.

 

Sparklines Ribbon

 

  1. Select the data range to create the sparkline for, and then select the location range for the sparkline.

 

Sparklines Select Single Cell

 

  1. Click OK.

 

Sparklines _ShowSparkline

 

A sparkline is added to the selected range (in this case, a single cell, G5) and a new tab called Sparkline appears on the Ribbon.

  1. Use the handle at the bottom right hand corner of the cell to copy the sparkline down to Rows 6–8.

 

Sparklines Copy Sparkline

 

  1. Select the range of cells for the Data Range as well as for the Location Range when creating the sparkline.

 

Sparklines Insert Multiple Sparklines

 

  1. Click OK to insert multiple sparklines into the worksheet.

 

Sparklines Show Multiple

 

Clear Sparklines

Select the sparklines you wish to clear and then in the Ribbon, select Sparklines > Clear > Clear Selected Sparklines.

 

Sparklines Clear

 

The Sparklines tab on the Ribbon then disappears.

Column Sparkline

  1. In the Ribbon, select Insert > Sparklines > Column.

 

Sparklines Insert Column

 

  1. Select the Data Range and Location Range as you did when inserting a Line Sparkline above, and then click OK.

 

Sparklines Column

 

Alternatively, if you already have line sparklines in the location range, you can change the type of sparkline to Column by selecting Sparkline > Type > Column in the Ribbon.

 

Sparklines Type

 

You can also use the Sparkline tab on the Ribbon to amend the Style and Color of the sparkline, or to show points on the sparkline.

Insert Sparklines in Google Sheets

Inserting sparklines in Google Sheets is completely different. In Google Sheets, you have to use a formula to insert sparklines.

  1. First select the cell where you want the sparkline to be shown.

 

Sparklines Google sheets select cell

 

  1. Then type the SPARKLINE Function formula and highlight or type the data range.
=SPARKLINES(C5:F5)

 

Sparklines Google Sheets Insert

 

  1. Press ENTER to insert the sparkline into the spreadsheet.

 

Sparklines Google Sheets Insert Sparkline

 

  1. Then use the handle at the bottom of the selected cell to copy the sparkline down to the cells below.

 

Sparkline Google Sheets Copy Down

 

Google Sheets Sparkline Options

There is no Sparkline tab in Google Sheets. Instead, the properties of sparklines are defined within the formula.

  1. To change the color of the sparkline, amend the formula.
=SPARKLINE(C5:F5, {"color","red"})

 

Sparklines Google Sheets Color

 

  1. To change the sparkline type to Column, you also need to amend the formula.
=SPARKLINE(C5:F5, {"charttype", "column"})

 

Sparklines Google Sheets Column

 

  1. To change the color and the type, you can combine the two options in one formula, separating them by means of a semicolon.
=SPARKLINE(C6:F6, {"color","blue"; "charttype", "column"})

 

Sparklines Google Sheets Column Color

 

  1. You can also change the color of the sparkline by changing the color of the text in the cell selected. In the Menu, select Text Color, and select a color.

 

Sparklines Google Sheets Line Color