Microsoft Office Tutorials and References
In Depth Information
Summarizing data using sparklines
Create a win/loss sparkline
1 Select the cells that you want to summarize.
2 Click the Insert tab.
3 In the Sparklines group, click Win/Loss.
4 Click the Location Range box.
5 Click the cell where you want the sparkline to appear.
6 Click OK.
CAUTIoN A win/loss sparkline distinguishes between positive,
negative, and zero values. Summarizing a series of monthly sales
values using a win/loss sparkline won’t provide any useful information.
However, comparing the sales figures to each month’s goal would be
appropriate for a win/loss sparkline.