Microsoft Office Tutorials and References
In Depth Information
Creating groups of sparklines
Creating groups of sparklines
It often makes sense to create groups of related sparklines—such as the ones in column C
in Figure 21-1. You can do this in either of two ways. The first is to create one member of
the group—say, the sparkline in cell C3 in Figure 21-1. After you do that, you can simply
drag the ill handle to generate the remainder of the set. Excel copies the sparkline
attributes of the first cell to the rest of the range, just as it would replicate a worksheet formula
or a set of formatting parameters.
The second way to create a set of related sparklines is to specify the entire block at once.
To set up the sparklines in Figure 21-1, for example, you could ill out the Create Sparklines
dialog box like this:
Whichever way you create the related sparklines, Excel treats the set as a group. When
you select any cell within the group, Excel draws a blue rectangle around the entire group,
and any formatting changes you make are applied to the whole set. If this is not what you
want—for example, if you need to change the weight or color of a particular sparkline
within the group—select any member of the group and then click Ungroup. If you change
your mind, select the entire set and click Group.
Expanding a set of sparklines
The monthly figures in Figure 21-1 extend from January through July. What do you do
when the August numbers arrive? The simplest way to expand the sparklines is to make the
original data set a table. (Select a cell and press Ctrl+T. For more information, see “Creating
a table” in Chapter 22, “Managing information in tables.”) When you add new columns to
the right edge of a table, the new columns join the table, and formulas and charts that
reference the table automatically incorporate the new data.
Search JabSto ::




Custom Search