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
Free Excel Dashboard Template File Download:
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!)
Thanks again for the submission Don. I loved it! Great technique and vision of the data.
Nicely done Don. I like the addition of the Oscar data.
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.
Thanks Don. Sorry it took so long (had a password problem :)), but I have just posted the updated file and your comments. Steve=True
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.
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!)
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
This dashboard is AMAZING! Any tips and/or locations on creating dashboard 101 would be appreciated!!!
It is on my plan to break it down. Hopefully soon. Thanks for the great comment. Steve=True