Microsoft Office Tutorials and References
In Depth Information
Summarizing your data by using sparklines
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
rightmost sparkline style. Excel changes the win/loss sparkline’s appearance.
Search JabSto ::




Custom Search