Microsoft Office Tutorials and References
In Depth Information
Sparklines: Mini-Charts with Big Impact
4. Click OK. The Sparklines in line-chart form should appear in the cells of the
location range—J10:J19, each Sparkline tied to each row of student data.
It’s all pretty easy. One subtle virtue of Sparklines is that you can select a large range of data—say,
daily stock closing prices for an entire year entered across one row, or down one column—and pack it
into one Sparkline, delivering a long-term, global picture of financial activity. Sparklines are also
dynamic—they will continue to register changes in the original source and change accordingly.
And note that because the Sparklines are lodged in cells just like other data, you can select a
Sparkline range, click the Home tab, and click the Fill Color button on the Font button group and color
the cells in which the Sparklines appear. You can then click the Sparkline Tools tab that has magically
appeared above the Design tab (Figure 5-73):
Figure 5–73. The Sparklines Tools tab
and then click the Sparkline Color button on the far right to recolor the Sparklines (Figure 5-74):
Figure 5–74. Where to color Sparklines
You can also modify the lines’ thickness with the Weight option on the same menu.
To emphasize data points in the Sparklines, move left to the Show group (Figure 5-75):
Figure 5–75. The Show group’s buttons, for emphasizing Sparkline data points