- Adding Sparklines to a Worksheet
- Understanding the Axis Size of Sparklines
- Creating Column Sparklines for High Temperature Data
- Forcing Each Sparkline to Have the Same Scale
- Adding Labels and Shading the Normal Range on a Sparkline
- Adding a Reference Line
- Adding Shading to Show the Normal Range
- Showing Negative Values
- Win/Loss Sparklines
Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Win/Loss Sparklines
The third type of sparkline is called Win/Loss. This sparkline shows an upward facing marker for positive values and a downward facing value for negative values. Zero values get no marker.
This type of chart allows you to focus on trends. There are many uses, such as stock market direction.
)
It can be used to track how many bids have been won over a certain period of time.
Win/Loss can be used to track a sports season. The following figure shows one of the most famous pennant races in baseball.
){kind=small}
Win/Loss can be used to track if something happened in a given time period. The following figure shows whether an artist had a hit in the Hot 100 for each year over five decades:
){kind=small}
To create a win/loss chart, you will probably have to use formulas to convert your data into 1s and -1s. The stock market win/loss chart used a formula such as that shown in the following figure.
)
Sparklines are a great idea from Professor Edward Tufte. Microsoft was able to jump on this idea quickly and incorporated it in Excel 2010.