Microsoft Office Tutorials and References
In Depth Information
Sparklines: Mini-Charts with Big Impact
Figure 5–71. The grade data, pre-sparkline
To start the Sparkline:
Select cells J10:J19. The Sparkline for each student will go here.
Click the Insert tab, and then, in the Sparklines button group, click Line . You’ll
see (Figure 5-72 ):
Figure 5–72. The Create Sparkines dialog box
In the Data Range field, click D10:H19—the range containing all the student
grades. Here, we’re not worried about that row containing the name Student or
that “Class Average” row—rows 9 and 20, respectively—because we’ve excluded
them from the data range.