Rio Olympics Visualization 2
Visualization 1 – Change in Rankings

 

Rio Olympics Visualization
Visualization 2 – Overall

 

Recently the Olympics have been the talk of the town! Personally I have been following Olympics for just 2 reasons

  1. To see the medal count for India
  2. To be astonished by the performance of US

 

When the Olympics ended I thought why not make a Dashboard and feed people with analytics of RIO and may be even compare it to London Olympics. Both of these are unlocked, rip them apart and see how did I put them together

 

Visualization 1 – Shift in Rankings

Rio Olympics Visualization 3

The Inspiration to make this visualization came from here. This was a tough one!! To get my head around this, I took almost 7 hours

 

Visualization 2 – Overall

Rio Olympics Visualization 4

This was not so difficult and I was done with this in about 2 hours.

 

30 Day Challenge Dashboard 7

  1. It contains both the visualizations!
  2. Be sure to enable macros before you start playing with it!
  3. Works well in Excel 2010 and above!!

 

Resources and Links

Here are a few things that will help you understand some of the concepts used in making both of the visualizations

  1. How to make a Scrolling list in Excel
  2. Beauty Tips for your Excel Dashboard
  3. How to get Vector Icons
  4. Dynamic Text Boxes in Excel
  5. Slicers in Excel
  6. Slicers Formatting in Excel

 

Some more kick ass Visualizations/Dashboards

  1. Cost Structure Visualization – From Chandoo’s Dashboard Contest
  2. 30 Day Challenge Dashboard
  3. Indian Republic Day Visualization
  4. Shift Between the Companies Chart
  5. Dashboard in 15 Mins

 

 



Topics that I write about...






Download Smart Ebooks on
Excel and Power BI