Microsoft Office Tutorials and References

In Depth Information

**Customizing Sparklines**

Figure 3-12:
Sparklines display the number of pages read per month.

The lower set of sparklines in Figure 3-13 shows another approach: Transforming the data so that

meeting the goal is expressed as a 1 and failing to meet the goal is expressed as a –1. The following

formula (in cell B18) transforms the original data:

=IF(B6>$C$2,1,-1)

This formula was copied to the other cells in the B18:G25 range.

Using the transformed data, Win/Loss sparklines are used to visualize the results. This approach is

better than the original, but it doesn’t convey any magnitude differences. For example, you cannot

tell whether the student missed the goal by 1 page or by 500 pages.

Figure 3-13:
Using Win/Loss sparklines to display goal status.