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


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

the link to file:



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s