As envisioned by Professor Tufte, sparklines could have a bit of shading to show the acceptable ranges. While this is not necessarily built into Excel 2010, you can achieve the same effect. Episode #1195 show you how
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
In Episode 1194, we take a look at how to add labels to your sparklines.
...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
Download a new two minute video every workday to learn one of the 377 tips from the book!
Robert asks about using a pivot table to report on text values. This would be easy if Microsoft offered a way to specify "First" as the calculation, but they don't. Instead, Episode #1193 shows a Pivot/VLOOKUP solution to the problem.
Mary asks about how to force a report to fit to one page wide. Episode #1192 takes a look at Layout mode, Scale to Fit, and orientation. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
This isn't so much of a dueling podcast as Bill being obnoxious and breaking Mike's worksheet. Maybe there is a use for this, or maybe not. Episode #1191 will show you how.
Excel 2007 offers a new way to set up non-contiguous print ranges. Episode #1190 shows you how. ...This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel.
Excel 2010 offers a cool trick that anyone with a browser can try out right now. You can view and edit your Excel workbooks in a browser. Episode 1189 shows you how to try it out.
In this Dueling Excel Episode, Find a value in this row and then get the values 1 and 2 columns to the right of that value. Mike and Bill duel it out in Episode #1188.
Howie asks why the fill handle does what it does when you select four numbers and drag. Episode #1187 discusses trend lines, LINEST, and straight line regression.
...This blog is the video podcast companion to the book, Learn Excel 97-2007.
