Microsoft Office Tutorials and References
In Depth Information
You Win Some, You Lose Some
Figure 5–78. All or nothing: Positive numbers win, negative numbers lose
Select this range, select the Sparklines Win/Loss chart, and select a one-cell location range to the
right of the range when prompted (though it can really be placed anywhere), and you’ll produce this
(Figure 5-79):
Figure 5–79. In the black: a win-loss chart
Notice there is no magnitude here. All the positive and negative values are recorded equally—
they’re in the same place, either above or below the axis. So why would you use Win/Loss? You could use
it to track the incidence of profits and losses in a business for example, though again, not their exact
values. Win/Loss is often applied to chart wins and losses of sports teams (hence its name); you could
enter a 1 for every team win along a selected range, and a -1 on that same range for every loss. Do this
across a 162-cell range and you could compile a trajectory of the fortunes of a major league baseball
team, by placing a Sparkline in the 163 rd cell—again, giving the big picture of an entire season. ( Note :
Widening a column, or heightening a row, in a Sparkline cell brings about the same kind of aspect ratio
distortion we discussed earlier).
To remove a Sparkline, just right-click it and select Sparklines Clear Selected Sparklines —it’s
expressed in the plural because you can drag across a range of Sparklines and delete the whole group.
There’s one other important Sparkline set of options, and you’ll find them when you click the Axis
down arrow, in the Sparkline button group (Figure 5-80):
Figure 5–80. Sparkline Axis options
Search JabSto ::

Custom Search