Visualizing Roger Federer’s 7th Wimbledon Win in Excel
Did I tell you I love tennis? Some of my personal heroes & motivators are tennis players. And as you can guess, I admire Roger Federer. Watching him play inspires me to achieve more. So last night when he lifted Wimbledon trophy for 7th time, I wanted to celebrate the victory too, in my style. So I made an interactive timeline chart in Excel depicting his victory.
See it below. (click here for high-res version)
How is this timeline made?
Here is the process in a gist.
- First I sourced the match data from Wimbledon.com. This is done by manually copy pasting or typing the data.
- Then, I created a massive grid of 240 columns by few rows. This is to be used as a timeline for the match (as the match lasted 4 hours, we need 240 columns, 1 for each minute)
- Then in a separate range, I identified whether an ace, break point etc. happened on each minute.
- Then we show one of these on the timeline based on what user selects
- Rest of the statistics are just plugged in using picture links.
- There is only one macro (just one line) that refreshes the screen when form control is changed (so that new conditional formats can kick in).
Download the interactive timeline:
Click here to download the workbook & play with it. You can select Aces, break points, games etc. to see key milestones on this 4 hour match timeline.
I am not explaining techniques in detail as most of my day is went in to constructing it. But you can easily break it apart and see how it works.
If you like this exceptional sportsman, congratulate him. Lets hope he continues to inspire us for few more years.
Thanks to Wimbledon.com & IBM Slamtracker from which I sourced this data.
Leave a Reply
|Creating a Masterchef Style Clock in Excel [for fun]||Highlight Row & Column of Selected Cell using VBA|