How to Ungroup Line Sparklines

Line Sparkline is one of the mini charts in a single cell, representing the trend of data that you have selected. Please see how to insert line sparklines. When you create the line sparklines, they come as a group. Please see the steps below to ungroup them:

Step 1: Select any cell with line sparklines;

Step 2: Click the "Design" tab from the Ribbon;

Step 3: Click the Ungroup command from the "Group" area;

Step 4: The line sparklines will ungroup;

Step 5: You can change any cell with a different type of sparkline.

Leave a Reply