Microsoft Office Tutorials and References
In Depth Information
Adding Sparklines and Data Bars
Excel supports the following three types of sparklines:
• A line sparkline for highlighting trends
• A column sparkline used for column charts
• A win/loss sparkline for highlighting positive and negative values
Figure 4-36 shows examples of each type of sparkline. The line sparklines show the
sales history of each department and all four departments for a computer manufacturer.
From glancing at the sparklines, you can quickly see the recent sales history within and
across departments. Notice that although total sales rose steadily during the year,
peripheral sales lagged for the ﬁ rst two-thirds of the year before increasing in the ﬁ nal third.
Types of sparklines
The column sparklines present a record of monthly temperature averages for four
cities. Temperatures above 0°C are presented in blue columns; temperatures below 0°C are
presented in red columns that extend downward.
Finally, the win/loss sparklines reveal a snapshot of the season results for four sports
teams. Wins are displayed in blue; losses are in red. From the sparklines, you can
quickly see that the Cutler Tigers ﬁ nished their 10-2 season with six straight wins and the
Liddleton Lions ﬁ nished their 3-9 season with four straight losses.
To create a set of sparklines, you ﬁ rst select a data range containing the data you want
to graph, and then you select a location range where you want the sparklines to appear.
Note that the cells in which you insert the sparklines need not be blank. Sparklines are
added as part of the cell background and do not replace any cell content.