Microsoft Office Tutorials and References
In Depth Information
Understanding Sparkline Groups
In most situations, you’fill probably create a group of sparklines — one for each row or column of data.
A worksheet can hold any number of sparkline groups. Excel remembers each group, and you can
work with the group as a single unit. For example, you can select one sparkline in a group, and then
modify the formatting of all sparklines in the group. When you select one sparkline cell, Excel displays
an outline of all the other sparklines in the group.
You can, however, perform some operations on an individual sparkline in a group:
Change the sparkline’s data source. Select the sparkline cell and choose Sparkline Tools
Edit Single Sparkline’s Data. Excel displays a dialog box
that lets you change the data source for the selected sparkline.
Delete the sparkline. Select the sparkline cell and choose Sparkline Tools
Clear Selected Sparklines.
Both operations are available from the shortcut menu that appears when you right-click a sparkline
You can also ungroup a set of sparklines by selecting any sparkline in the group and choosing Sparkline
Ungroup. After you ungroup a set of sparklines, you can work with each
When you select 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 19.30
shows the same sparkline, displayed at four sizes resulting from column width, row height,
and merged cells. As you can see, the size and proportions of the cell (or merged cells) make
a big difference in the appearance.