Sparklines

 

Insert Sparklines    |   Customize Sparklines

Excel 2010 makes it possible to insert sparklines. Sparklines 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

Advertisement

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.

Choose Data

4. Click OK.

Result:

Sparklines

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. The Sparkline Tools contextual tab activates.

2. Check High Point and Low point.

Check High Point and Low Point

Result:

Highest and Lowest Points

3. In the Type group, click Column.

Click Column

Result:

Column Sparklines

4. To delete a sparkline, select a sparkline and click on the Clear button.

Clear Sparkline

Advertisement

Please show your appreciation by sharing this page

Go back to charts, Go to the right >>
Go to Top: Sparklines    |    Go to Next Example: Combination Chart