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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920