How To Use sparklines to show data trends In Excel

Mar 25, 2020

Looking for a way to visualize a large volume of data in a little space? Sparklines are a quick and elegant solution. These micro-charts are specially designed to show data trends inside a single cell.

In this article, you’ll learn all about Excel Sparklines and see some useful examples of it.

Sparklines in Excel are graphs that fit in one cell and give you information about the data.

Insert Sparklines

To insert sparklines, execute the following steps.

1. Select the cells where you want the sparklines to appear. In this example, we select the range G2:G4.

Data in Excel

2. On the Insert tab, in the Sparklines group, click Line.

Click Line

3. Click in the Data Range box and select the range A2:F4.

Create Sparklines

4. Click OK.


Sparklines in Excel

5. Change the value of cell F3 to 0.

Result. Excel automatically updates the sparkline.

Updated Sparkline

Customize Sparklines

To customize sparklines, execute the following steps.

1. Select the sparklines.

2. On the Design tab, in the Show group, check High Point and Low point.

Check High Point and Low Point


Highest and Lowest Points

3. On the Design tab, in the Type group, click Column.

Click Column


Column Sparklines in Excel

To delete a sparkline, execute the following steps.

4. Select 1 or more sparklines.

5. On the Design tab, in the Group group, click Clear.

Clear Sparkline

#Tutorial#How To#Data Analysis

How to use Goal Seek analysis tool In Excel

How to Calculate Compound Annual Growth Rate in Excel