Microsoft Office Tutorials and References
In Depth Information
Understanding Sparkline Groups
Most of the time, you’ll 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. Click the sparkline cell and go to the Sparkline Tools tab
on the Ribbon. There you can choose Design➜Sparkline➜Edit Data➜Edit Single Sparkline’s
Data. Excel displays a dialog box that lets you change the data source for the selected
Delete the sparkline. Click the sparkline, click the Sparkline Tools tab on the Ribbon, and then
select Design➜Group➜Clear➜Clear Selected Sparklines.
Both operations are available from the shortcut menu that appears when you right-click a
You can also ungroup a set of sparklines. Select any sparkline in the group and then, from the
Sparkline Tools tab, select Design➜Group➜Ungroup. After you ungroup a set of sparklines, you
can work with each sparkline individually.
Ungrouping sparklines gives you the ability to move, size, and format them separately on your
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 Design tab (select Sparkline Tools➜Design tab)
to customize the group of sparklines.
Sizing and merging sparkline cells
When you change the width or height of a cell that contains a sparkline, the sparkline adjusts to fill
the new cell size. In addition, you can put a sparkline into merged cells. To merge cells, select at least
two cells and choose Home➜Alignment➜Merge & Center.
Figure 3-7 shows the same sparkline, displayed at four sizes resulting from column width, row height,
and merged cells.