Excel 2010 Bible

Chapter 21: Creating Sparkline Graphics

507

Figure 21.4 shows column Sparklines for the precipitation data.

FIGURE 21.4

Column Sparklines summarize the precipitation data for nine cities.

Customizing Sparklines

When you activate a cell that contains a Sparkline, Excel displays an outline around all the

Sparklines in its group. You can then use the commands on the Sparkline Tools ➪ Design tab to

customize the group of Sparklines.

Sizing Sparkline cells

When you change the width or height of a cell that contains a Sparkline, the Sparkline adjusts

accordingly. In addition, you can insert a Sparkline into merged cells.

Figure 21.5 shows the same Sparkline, displayed at four sizes resulting from column width, row

height, and merged cells.

FIGURE 21.5

A Sparkline at various sizes.