Microsoft Office Tutorials and References
In Depth Information
Figure 3-3: Three types of sparklines.
Figure 3-4 shows some weather data that you can summarize with sparklines. To create sparkline
graphics for the values in these nine rows, follow these steps:
1. Select the data range that you want to summarize. In this example, select B4:M12.
If you’re creating multiple sparklines, select all the data.
Figure 3-4: Data that you want to summarize with sparkline graphics.
2. With the data selected, click the Insert tab on the Ribbon and find the Sparklines group.
There you can select any one of the three sparkline types: Line, Column, or Win/Loss. In this
case, select the Column option.
Excel displays the Create Sparklines dialog box, as shown in Figure 3-5.