In keeping with the spirit of the 2008 Summer Olympics, I’ve been posting some data visualizations and dashboards related to the Beijing Games. On Dashboards by Example we saw the Olympics Dashboard done in Adobe Flex by iDashboards and, on The Dashboard Spy, we saw the New York Times Olympic Medal Count Infographic.
As a reminder, let’s gawk again at the NY Times work of art. You can view the flash-based graphic at http://www.nytimes.com/interactive/2008/08/04/sports/olympics/20080804_MEDALCOUNT_MAP.html .
You’ll have to visit the actual infographic to have it work, but once you get there just follow these instructions:
Circles are sized by the number of medals that countries won in summer Olympic Games. Use the slider to view past Olympics, or click on a country to display a list of its medal winners.
The point of today’s post, however, is to laud the work of a Microsoft Excel enthusiast in this area. Chandoo, editor of the hilariously-named PointyHairedDilbert:Excel Tips, Technology Tidbits & Business Insights, has created the following Excel-based version of the New York Times Olympic Medal bubble chart:
Isn’t that great? Moreover, Chandoo details how he created this in Excel:
In his post titled, Doing the NY Times Olympic Medals by Country & Year Visualization in Excel, Chandoo offers the Olympic Medals Bubble Chart Excel Worksheet as a download.
Great work, Chandoo! I’ve just added you and your Excel blog as an expert resource. See The Dashboard Spy’s Big List of Experts.
Have a look at his great post. Here’s a snippet of what you’ll find. Also, in the comments, you’ll find Dashboard Spy reader and Excel Visualization Ace, Jon Peltier explaining a technique to change the color of the bubbles based on the country it belongs to.
Update: Based on contributions by his readers, Chandoo has posted additional excel files for us to play with. See his second post titled The Olympic Medals by Country Chart – Now Improved. There is the version by Jon Peltier and the alternate approach by Robert from Germany as shown in this screenshot.
Note: Use the links in the paragraph above for the downloads, not the ones in the following image as they will not work.
Tags: Olympic Medal Data Visualization, Excel Dashboards, Excel data visualization