Monday, September 26, 2011

Sparklines

Application: Excel 2010

Sparklines are small charts that fit into one cell to visually summarize trends alongside data. Sparklines can be shown as a line, column, or win/loss format. When Sparklines are created, the Sparklines tools become available so that colors, placement, and styles can be modified.
Adding Sparklines
1.    In Excel, select an empty cell.
2.    Click the Insert tab. In the Sparklines group, select Line, Column, or Win/Loss.
3.  The Create Sparklines dialog box will appear. In the Data Range field, enter the cells to be used in the Sparkline calculation. In the Location Range field, enter the cell where the Sparkline is to be placed.
4.  Click OK.

No comments: