Here is our next submission from the last Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel Dashboard entry from Don.
In the Free Sample Dashboard Template file you will see the following Excel techniques:
1) Gauge Chart (Odometer Chart)
2) Scroll Bar Table and Chart
3) Hyperlink Picklist
4) Bin Chart
5) Scrolling Pivot Table List
Check out the video and download the file below. Also, let us know what you think in the comments below. Thanks and more to come this month on ExcelDashboardTemplates.com
Video Review:
This embedded resource is unavailable in the restored edition.
Free Excel Dashboard Template File Download:
Friday-Challenge-Dashboard-V2-Don.xlsx
Don provided an updated file where he changed how the slicers work. On the slicer, you can hold down the shift key and get a time period (multiple years) for best movie, not just one years. For example, from 1950 to 1959 the highest ranking movie was 12 Angry Men. (Thanks Don!)
Friday-Challenge-Dashboard-V2-2-Don.xlsx
Thanks again for the submission Don. I loved it! Great technique and vision of the data.
Steve=True
Reader discussion
Comments preserved from the original page. New comments are closed.
Reader
December 9, 2013 At 3:47 am
Nicely done Don. I like the addition of the Oscar data.
Reader
December 10, 2013 At 12:20 pm
I sent in a revised copy with the extra years taken out of the slicer. The slicer was intended to pick a period of time (i.e. 1950 through 1959), not just one year at a time.
Reader
December 16, 2013 At 9:54 pm
Thanks Don. Sorry it took so long (had a password problem :)), but I have just posted the updated file and your comments. Steve=True
Reader
December 12, 2013 At 2:24 pm
Thanks Pete
Reader
February 24, 2014 At 12:08 am
HiDon!
I really like this dashboard, specially the odometer. Is it possible to make this with the color opposite? I’d like to have red where it’s green and green where it’s red. And in between the color yellow if possible. I have tried the “various color” but I can´t choose the colors that I want.I hope you can help me.
Reader
July 10, 2014 At 3:30 pm
Hi,
I have only excel 2003 on work PC and I was wondering if you could me a tutorial of how to make each piece of this dashboard and it’s dynamics for my version (no slicers!)
Thanks
Reader
July 17, 2014 At 11:34 am
Hi Nicole,
That is a great question. It can be done, however, I don’t have a computer with Excel 2003 🙁 Maybe I can do it in 2007 and you can translate to how you can do it in Excel 2003.
I will see what can be done. However, how for the one component with the slicer, how would you as a user want to pick multiple years? Since there were 80 or so years, I would imagine that it would have to be in another tab of the spreadsheet, but I wanted your thoughts. Steve=True
Reader
November 2, 2014 At 8:58 am
This dashboard is AMAZING! Any tips and/or locations on creating dashboard 101 would be appreciated!!!
Reader
November 3, 2014 At 8:30 am
Hi Stephanie,
It is on my plan to break it down. Hopefully soon. Thanks for the great comment. Steve=True