Excel Datavis Contest @ Chandoo.org – My Entry

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

mydashboard

move your mouse over the state name and the data gets updated for the year selected

the link to file:

https://drive.google.com/file/d/0B2FLZ9YjqpJTd1NWX21nUkUwcHM/edit?usp=sharing