Site icon ExcelNotes

How to Set up the Same Min Vertical Value for all Sparklines

Please see the steps below to set up the same min vertical value for all sparklines:

Step 1: Select any cell with line sparklines;

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

Step 3: Click the Axis command from the "Group" section;

Step 4: Click the "Same for All Sparklines" command under "Vertical Axis Minimum Value Options";

Step 5: You will see the sparklines move a bit and the sparklines have the same minimum vertical values.

Exit mobile version