How to Insert Sparklines in Excel 2010

Sparklines is a cool feature that lets you analyze cell data in graphical terms. This tutorial shows you how to insert sparklines in Excel 2010, then detail steps on how to edit the Sparkline’s data source and if required delete a sparkline. The Create Sparklines dialog box contains the Data Range text box which allows you to enter the Sparkline data range and the Location Range text box that allows you to enter the cell location where you want to insert the Sparkline.

 How to Insert Sparklines in Excel 2010

1. On the Insert tab, in the Sparklines group, click a Sparkline type.

2. The Create Sparklines dialog box is displayed. In the Data Range text box, click the Collapse Dialog toggle button and navigate to the sheet that contains the data range.

3. To insert a Sparkline in a single cell, select one single data range. To insert more than one Sparkline, select the entire data range or as required.

4. Click the Expand Dialog toggle button and place the insertion point in the Location Range text box.

5. Click the Collapse Dialog toggle button, navigate to the sheet where you want to insert the Sparkline(s) and click OK.

6. If you have inserted a Sparkline in a single cell, you can drag the fill arrow to fill the Sparklines in the remaining cells.

How to Insert Sparklines in Excel 2010

Edit the Sparkline’s Data Source

If you want to edit data that sources the Sparkline, here’s what you need to do.

1. Select the Sparkline.

2. In the Sparkline Tools Design contextual tab, in the Sparkline group, click Edit Data.

3. Modify the information in the Data Range and Location Range text boxes.

Delete a Sparkline

You can delete a Sparkline by performing the below mentioned steps.

1. Select the Sparkline.

2. On the Sparkline Tools Design contextual tab, in the Group group, from the Clear drop down, select Clear Selected Sparklines to clear a selected Sparkline or select Clear Selected Sparkline Groups to clear a selected Sparkline group.

Follow us on Twitter, Facebook or Google +to get the latest tutorials, updates and how-to articles on Microsoft, Google and Apple products.