Microsoft Office Tutorials and References
In Depth Information
Creating Sparkline Graphics
h Win/Loss: A binary-type chart that displays each data point as a high block or a low block.
The third group shows win/loss Sparklines. Notice that the data is different. Each cell
displays the change from the previous month. In the Sparkline, each data point is depicted as
a high block (win) or a low block (loss). In this example, a positive change from the
previous month is a win, and a negative change from the previous month is a loss.
To create Sparkline graphics, select the data that will be depicted. Then choose Insert
and click one of the three Sparkline types: Line, Column, or Win/Loss. Excel displays the Create
Sparklines dialog box, where you specify the location for the Sparklines.
Typically, you’ll put the Sparklines next to the data, but that’s not a requirement. Most of the
time, you’ll use an empty range to hold the Sparklines. However, Excel does not prevent you
from inserting Sparklines into cells that already contain data. The Sparkline location that you
specify must match the source data in terms of number of rows or number of columns.
After you create some Sparklines, you have a fair amount of control over their appearance. Use
the tools in the Sparkline Tools Design tab (which appears when you select a cell that contains a
Figure 150-2 shows a group of Sparklines in the range H3:H12, plus a line chart that uses the same
data. The line chart is a bit jumbled, but it’s a better choice if you want to compare the cities. The
Sparklines, on the other hand, are useful for showing trends for a single city.
Figure 150-2: A group of Sparklines, and a line chart that shows the same data.