Part III: Creating Charts and Other Visualizations
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 22.5 shows the same Sparkline, displayed at four sizes resulting from changing the
column width or row height and merging cells. As you can see, the size and proportions of
the cell (or merged cells) make a big difference in the appearance.
FIGURE 22.5
A Sparkline at various sizes
Handling hidden or missing data
By default, if you hide rows or columns that are used in a Sparkline graphic, the hidden
data does not appear in the Sparkline. Also, missing data (an empty cell) is displayed as a
gap in the graphic.
To change these settings, choose Sparkline Tools Design ➪ Sparkline ➪ Edit Data ➪ Hidden
and Empty Cells. In the Hidden and Empty Cell Settings dialog box that appears (see
Figure 22.6), specify how to handle hidden data and empty cells.
FIGURE 22.6
The Hidden and Empty Cell Settings dialog box
