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