excel tutorialExcel 2010 Sparklines
Excel 2010 makes it possible to insert sparklines. Sparklines are graphs that fit in one cell and give you information about the data. This chapter illustrates how to insert and customize sparklines.
Insert a Sparkline
To insert a sparkline, open the accompanied Excel file, and execute the following steps.
1. Select the cells where you want the sparklines to appear. In this example, we select the range with address G2:G4.
2. On the Insert tab, choose Line under the Sparklines group.
3. Enter the data you want to use for the Sparklines. In this example, we use the range with address A2:F4.
Result:
4. Change the value of cell C2 to 25.
Result:
The sparklines change dynamically depending on the cell's value.
Customize the Sparkline
To further customize the sparkline, execute the following steps.
1. Select the sparklines. The Sparkline Tools contextual tab activates automatically.
2. Check High Point and Low point to highlight the highest and lowest point of data in the selected sparkline group.
Result:
4. Click on Column under the Type group to change the selected sparkline group to column sparkline.
Result:
5. If you want to delete a sparkline, select the sparkline and click on the clear button.
That was it.
Did you like this free Excel tutorial? Show your appreciation, vote for us.