Page 560 - Excel 2013 All-in-One For Dummies

542 Adding Sparkline Graphics to a Worksheet
The Insert Chart dialog box appears with the Recommended Charts tab selected.
3. Click the All Charts tab and then select the Templates option in the Navigation pane of the Insert Chart dialog box.
Excel then displays thumbnails for all the chart templates you’ve saved in the main section of the Create Chart dialog box. To identify these thumbnails by filename, position the mouse pointer over the thumbnail image.
4. Click the thumbnail for the chart template you want to use to select it and then click OK.
As soon as you click OK, Excel applies the layout and all the formatting saved as part of the template file to the new embedded chart created with the data in the current cell selection.
Adding Sparkline Graphics to a Worksheet
Excel 2013 supports a type of information graphic called sparklines that represents trends or variations in collected data. Sparklines — invented by Edward Tufte — are tiny graphs (generally about the size of text that surrounds them). In Excel 2013, sparklines are the height of the worksheet cells whose data they represent and can be any one of following three chart types:
✦ Line that represents the selected worksheet data as a connected line showing whose vectors display their relative value
✦ Column that represents the selected worksheet data as tiny columns
✦ Win/Loss that represents the selected worksheet data as a win/loss chart whereby wins are represented by blue squares that appear above the red squares representing the losses
To add sparklines to the cells of your worksheet, you follow these general steps:
1. Select the cells in the worksheet with the data you want represented by a sparkline.
2. Click the type of chart you want for your sparkline (Line, Column, or Win/Loss) in the Sparklines group of the Insert tab or press Alt+NSL for Line, Alt+NSO for Column, or Alt+NSW for Win/Loss.
Excel opens the Create Sparklines dialog box, which contains two text boxes: Data Range, which shows the cells you selected with the data you want graphed, and Location Range, where you designate the cell or cell range where you want the sparkline graphic to appear.
3. Select the cell or range of cells where you want your sparkline to appear in the Location Range text box and then click OK.