About one and a half month back Chandoo.org opened Excel Datavis Contest – 2014
The results are delayed but going to be out in about 2 weeks time. I present you my entry for the contest
The data given was US states to states migration over a period of three years and we were required to make a dashboard based on data. More details can found on the website.
I used features like data validation, bar chart, roll over macro, formulas like index, match, large etc
the US map is inserted with page layout -> page set up -> background
a screenshot of my dashboard is shown below
move your mouse over the state name and the data gets updated for the year selected
the link to file: