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.

Leave a Reply