Microsoft Office Tutorials and References
In Depth Information
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:
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.