Excel - Consistent Scale For Multiple Sparklines In Excel - Episode 1211.133

3,858 views · Published 17 July 2010 · 2:04 · Indexed 8 November 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Improving your sparklines with two simple settings.

Welcome back to the MrExcel netcast! In this episode, we will be diving into chapter 33 of our Excel in-depth series, where we will be discussing Sparkline Axis. As always, this netcast is sponsored by MrExcel.com, making your Excel experience even easier.

Sparklines are a relatively new feature in Excel 2010 and they are pretty cool, but there are a few things you need to be careful about when using them. To create Sparklines, you first need to select the data that you want to appear in the Sparklines. Then, go to the Insert tab and choose the type of Sparkline you want, such as Column or Line. Next, you need to select where you want the Sparklines to appear, either in 3 cells or 12 cells, depending on the size of your data. This will tell Excel which way the data should be displayed.

In this example, we have monthly temperatures for Chicago, Juneau Alaska, and Tucson Arizona. At first glance, it may seem like Juneau has the same temperature as Chicago and Tucson, but that can't be right. This is where the concept of different measures comes into play. Based on Edward Tufte's book, we can see how different measures can be displayed on the same scale and trend together over time. However, in this case, all the temperatures are on the same scale, so we need to take control of the Axis to accurately display the data.

To do this, select the Sparkline and go to the Sparkline tools design tab. Under the Axis drop-down, choose "Same for All Sparklines" for both the Minimum and Maximum options. This will ensure that all the Sparklines are displayed on the same scale, allowing us to accurately compare the temperatures. As a result, we can see that Tucson has the highest temperature, followed by Chicago, and then Juneau. This one simple setting can make a big difference in how your Sparklines are interpreted. Thanks for tuning in and we'll see you next time for another netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents
(00:00) Consistent Scale For Multiple Sparklines In Excel
(00:19) Creating Sparklines in Excel
(00:44) Comparing multiple sparklines
(01:10) Sparkline default is different axes
(01:29) Make axis consistent for all sparklines
(01:49) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #charts #excelcharts #excelchartstutorial #sparklines 

This video answers these common search terms:
how to make sparklines in excel consistent scale
consistent scale for multiple sparklines in excel
how to use sparklines in excel
making excel sparklines have the same scale
adjusting sparkline scales to match in excel
how to create sparklines excel
uniform scale for excel sparklines
aligning sparkline scales in excel
how to format sparkline in excel
how to format sparklines in excel
how to change sparklines to columns in excel
how to add sparklines in excel
ensuring identical sparkline scales in excel
setting uniform sparkline scales in excel
synchronizing sparkline scales in excel
equalizing sparkline scales in excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152897/




Based on the examples in Professor Tufte's book, the Excel team decided that the min and max axis values in sparklines should vary from chart to chart. Two simple changes can dramatically improve your sparklines.

More from this channel