• Excel Book Excerpt

Excel Sparklines Are Not Scaled Together

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

Sparklines Are Not Scaled Together

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

LE10001126.jpg 

Figure 1093 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.

LE10001127.jpg 

Figure 1094 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.

LE10001129.jpg  

Figure 1095 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.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: