47
TIP
Remember that sparklines work best when displayed in compact form. If you find
yourself adding markers and labels to a sparkline, you might consider using a regular chart
to take advantage of its wider range of formatting and customization options.
In this exercise, you’ll create a line, column, and win/loss sparkline, change the sparkline’s
formatting, and clear a sparkline from a cell.
SET UP
You need the RevenueSummary workbook located in the Chapter09 practice
file folder to complete this exercise. Open the workbook, and then follow the steps.
1
Select the cell range C3:C14.
2
On the Insert tab, in the Sparklines group, click Line to open the Create Sparklines
dialog box.
3
Verify that C3:C14 appears in the Data Range box. Then, in the Location Range box,
enter
G3
and click OK. Excel creates a line sparkline in cell G3.
4
Select the cell range C3:C14.
5
On the Insert tab, in the Sparklines group, click Column. The Create Sparklines
dialog box opens again.
6
Verify that C3:C14 appears in the Data Range box. Then, in the Location Range box,
enter
H3
and click OK. Excel creates a column sparkline in cell H3.
7
Drag the right edge of the column H header to the right until the cell’s width is
approximately doubled. Excel displays more details in the sparkline.
8
Select the cell range E3:E14.
9
On the Insert tab, in the Sparklines group, click Win/Loss. The Create Sparklines
dialog box opens again.
10
Verify that E3:E14 appears in the Data Range box. Then, in the Location Range box,
enter
I3
and click OK. Excel creates a win/loss sparkline in cell I3.
11
With cell I3 still selected, on the Design tool tab, in the Style gallery, click the right-
most sparkline style. Excel changes the win/loss sparkline’s appearance.
272
Chapter 9 Creating charts and graphics