|
Tips and Tricks - Microsoft Excel 2010 |
Create powerful data insights and visuals 
The Sparklines feature in Excel 2010 enables you to present a clear and compact visual of your data in small charts within a worksheet cell.
To use it:
- Select the cells in which you would like to place Sparklines
- On the Insert tab, in the Sparklines group, click Line, Column, or Win/Loss
- In the Create Sparklines dialog box, select the associated values from which to create Sparklines - do not include data labels when selecting associated values.
To customise your Sparklines
- Select cells containing Sparklines
- On the Sparkline Tools Design tab, which displays automatically, find options to change the Sparkline type, style, and others
Use the clear options to remove Sparklines
