Excel 2019 Bible

Part III: Creating Charts and Other Visualizations

FIGURE 22.9

Sparklines display the number of pages read per month.

Figure 22.10 shows another approach: transforming the data such that meeting the goal is

expressed as a 1 and failing to meet the goal is expressed as a –1. We used the following

formula (in cell B18) to transform the original data:

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

FIGURE 22.10

Using Win/Loss Sparklines to display goal achievement

We copied this formula to the other cells in the B18:G25 range.