- Adding Sparklines to a Worksheet
- Understanding the Axis Size of Sparklines
- Creating Column Sparklines for High Temperature Data
- Forcing Each Sparkline to Have the Same Scale
- Adding Labels and Shading the Normal Range on a Sparkline
- Adding a Reference Line
- Adding Shading to Show the Normal Range
- Showing Negative Values
- Win/Loss Sparklines
Forcing Each Sparkline to Have the Same Scale
The Sparkline Tools Design ribbon tab has an Axes drop-down near the right side. Open the drop-down and you will see that by default, the sparklines have "Automatic for Each Sparkline" as the setting for both the Vertical Axis Minimum and the Vertical Axis Maximum.
One choice is to change both of these settings to use "Same for All Sparklines".
This will result in the sparklines shown in the following figure.
This improves the scale problem; January in Miami now appears larger than January in Chicago. Using "Same for All Sparklines" allows Excel to recalculate the minimum and maximum axis value in response to the data changing. However, since sparklines will never label themselves, there is no way to know exactly what min and max Excel is using.
Perhaps because I have control issues, I find that I almost always use the Custom Value to lock the Min and Max values to some value that I choose.
Choosing a custom minimum of 0 and a custom maximum of 0 will lead to the sparklines shown in the following figure.
Using a custom min and custom max value is essential if you hope to add shading, lines, or labels to your sparklines.