Group, Ungroup, and Clear Sparklines
- Group: It groups all the sparklines together. In simple words, you can treat all the sparklines as having the same characteristics and applying style on any one of them, styles all the other sparklines in that group. If we change the color of one sparkline, all the other sparklines get affected.
- Ungroup: Ungroup option reverses the effects done by the Group option, it again makes the sparklines as different entities.
- Clear: This option can clear/delete the selected sparkline or the selected sparkline group( all the sparklines in that group ).
Sparklines in Excel : Add, Types, Delete
The sparklines are also known as in-line charts. So the question is where do we use sparklines, we can use them in situations where we want the graph/chart to be as near to the data as possible. Mainly we write data in one row / one column and add a sparkline to the end of the row or end of the column.