Based on the examples in Professor Tufte's book, Excel can show min and max axis values in sparklines and can vary from chart to chart.
Two simple changes will dramatically improve your sparklines in Excel! Episode #1248 shows you how!
Two simple changes will dramatically improve your sparklines in Excel! Episode #1248 shows you how!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Depth, chapter 33.
Sparkline Axis.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Well, sparklines are brand new in Excel 2010, and they're pretty cool.
But, there's a couple things you have to be careful about with sparklines.
Now to create sparklines choose the day that you want to have appear in the sparklines.
We go to insert this data, be really good for a spark column.
So, I choose column and then it wants to know where you want to put the data.
All right! So, I have three rows, twelve columns.
Either have to choose three cells or twelve cells and that'll tell Excel which way the data goes.
I'll choose three cells right here Click [ OK ].
All right! So, these are monthly temperatures as you can see, Chicago, Juneau, Alaska and Tucson, Arizona, and as you look at it.
It looks like Juneau is just as warm as Chicago and just as warm as Tucson and there's like no way, right.
So, here's what's going on, but he's done.
Edward Tufte's book.
Tufte's had a lot of examples, where he was showing spark lines of different measures and showing how they they trend together over time.
So, Microsoft made that be the default that you could have different measures here.
But, in this case these are all temperatures that are all the same scale and so, we want to be able to take some control of this and say hey!
We want to control the axis.
So, with the sparkline selected, you see we have spark line tools design here.
There's an axis drop down.
Underneath the axis drop down.
We want to choose same for all spark lines both for the minimum and for the maximum.
Same for all sparklines.
Otherwise what it's doing is basically showing us the range.
Alright! So, now we do this and as expected, Tucson is the...
Largest month.
Chicago, gets warm in the summer, but not as warm as Tucson and then, Juneau doesn't get as warm at all.
So, that one simple setting I can really...
Hey! Thank you for stopping by.
See you next time for another netcast from MrExcel.
Excel in Depth, chapter 33.
Sparkline Axis.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Well, sparklines are brand new in Excel 2010, and they're pretty cool.
But, there's a couple things you have to be careful about with sparklines.
Now to create sparklines choose the day that you want to have appear in the sparklines.
We go to insert this data, be really good for a spark column.
So, I choose column and then it wants to know where you want to put the data.
All right! So, I have three rows, twelve columns.
Either have to choose three cells or twelve cells and that'll tell Excel which way the data goes.
I'll choose three cells right here Click [ OK ].
All right! So, these are monthly temperatures as you can see, Chicago, Juneau, Alaska and Tucson, Arizona, and as you look at it.
It looks like Juneau is just as warm as Chicago and just as warm as Tucson and there's like no way, right.
So, here's what's going on, but he's done.
Edward Tufte's book.
Tufte's had a lot of examples, where he was showing spark lines of different measures and showing how they they trend together over time.
So, Microsoft made that be the default that you could have different measures here.
But, in this case these are all temperatures that are all the same scale and so, we want to be able to take some control of this and say hey!
We want to control the axis.
So, with the sparkline selected, you see we have spark line tools design here.
There's an axis drop down.
Underneath the axis drop down.
We want to choose same for all spark lines both for the minimum and for the maximum.
Same for all sparklines.
Otherwise what it's doing is basically showing us the range.
Alright! So, now we do this and as expected, Tucson is the...
Largest month.
Chicago, gets warm in the summer, but not as warm as Tucson and then, Juneau doesn't get as warm at all.
So, that one simple setting I can really...
Hey! Thank you for stopping by.
See you next time for another netcast from MrExcel.
