Excel: Sparklines Are Not Scaled Together

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: The vertical scale on the sparklines seems to be wrong. This chart is showing that Chicago and Miami have similar January temperatures.

  1. Monthly temperatures in Miami are not like Chicago.

    Strategy: by default, each sparkline has its own vertical scale. This works out great when the sparklines are comparing how different items trend together over time.

  2. Each sparkline has its own vertical scale.

    In Professor Tufte's first examples, he was comparing unlike variables that had a relationship. This is why Microsoft chose to keep the axes separate for each line.

    When you are comparing items that all have the same scale, you have to force the minimum and maximum axis to be the same.

    At the very least, use the Axis dropdown and choose Same For All Sparklines for both the minimum and maximum value.

  3. Make all of the axes the same.

    If you are going to be labeling sparklines or shading sparklines as described later, you will want to use a Custom Value for both the min and max value options.