Blogs

Sparklines feature in Excel 2010

By ILTA Tips posted 12-09-2013 00:00

  

2013/12/09

 

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 Sparklines: 
  1. Select the cells in which you would like to place Sparklines. 
  2. On the Insert tab, in the Sparklines group, click Line, Column, or Win/Loss
  3. 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 customize your Sparklines:
  1. Select cells containing Sparklines. On the Sparkline Tools Design tab, which displays automatically, find options to change the Sparkline type, style, and more. 
  2. Use the Clear options to remove Sparklines.

0 comments
9 views

Permalink