Page 42 - Computer - 7
P. 42
2. On the Insert tab, click the type of sparkline that
you want to create: Line, Column or Win/Loss in
the Sparklines group. 3
The Create Sparklines dialog box opens.
3. Verify that the data you selected appears in the
Data Range box. 4
4. Select the cell or cell range where you want the
sparkline to appear in the Location Range box.
5
5. Click the OK button.
The sparkline is created in the selected
cell.
The Sparkline Tools Design tab appears on the Ribbon.
To change the sparkline style:
1. Select the cell range that contains the sparkline you want to format.
2
1
2. On the Sparkline tab, click the More button in the Style group.
The Sparkline Styles gallery opens. 3
3. Select the desired style.
The selected style is applied to the sparklines.
To apply markers on the sparklines:
1. Select the sparkline.
2. On the Sparkline tab, mark the check box for the desired marker option in the Show group.
2
40
