Page 32 - Code & Click - 7
P. 32
To create a Sparkline: 2
1. Select the data you want to visualise
into Sparkline.
2. On the Insert tab, click the type of
sparkline that you want to create: Line,
Column or Win/Loss in the Sparklines
group.
The Create Sparklines dialog box
opens.
1
3. Verify that the data you selected appears in the Data Range
3 box.
4. Select the cell or cell range where you want the sparkline to
4 appear in the Location Range box.
5. Click the OK button.
5
The sparkline is created in the selected cell.
The Sparkline 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
30
