In my previous post, you learned How to Insert Sparklines in Excel 2010. If you have already been through my post View Trends in Data Using Sparklines, you will know that Sparklines are inserted in a single cell. If you want to view Sparklines in a range of cells, you can group them. Grouping Sparklines enables you to apply quick formatting to all of them in a few mouse clicks. In this tutorial, I’ll show you how to group and delete sparklines in Excel 2010.
How to Group and Delete Sparklines
Group Sparklines
To view Sparklines in a range of cells, simply click and drag the fill arrow that is displayed at the bottom of the cell. This will automatically group the Sparklines and any formatting changes made to a Sparkline in one cell will automatically be updated to all Sparklines in the group. If you want to format individual Sparklines, you can ungroup them and then apply the formatting for each individual Sparkline. Here is a simple two-step procedure to group Sparklines.
How to Group a Sparkline
1. Select a Sparkline.
2. On the Sparkline Tools Design contextual tab, in the Group group, click Group.
How to Ungroup a Sparkline
1. Select a Sparkline.
2. On the Sparkline Tools Design contextual tab, in the Group group, click Ungroup.
Delete a Sparkline
You cannot delete a Sparkline by pressing Delete on your keyboard as you would normally. Here’s how you do it.
How to Delete a Sparkline
1. Select the Sparkline.
2. On the Sparkline Tools Design contextual tab, in the Group group, from the Clear drop down, select Clear Selected Sparklines to clear a selected Sparkline or select Clear Selected Sparkline Groups to clear a selected Sparkline group.
I hope that these simple steps will help you effectively work with Sparklines.
About Adeline
