Online Data and Charts with Swivel

I recently came across the OECD Factbook blog written by Jérôme Cukier, who works as a data editor for the OECD. He has an excellent post on publishing charts in blogs.

As regular readers of the Mule will know, I don’t mind posting the odd chart and in the process I have grappled with the less than ideal results that the Excel to image production-cycle can produce. Jérôme’s process discusses these challenges and illustrates the results of different techniques (although I had more luck with copying as a picture and saving to PNG format than he had, so perhaps the choice of picture editor is a factor as well). As far as possible, I try to avoid using Excel altogether for producing charts and instead use the statistical package R, which can produce charts directly to a number of image formats including JPG and PNG. Although Jérôme doesn’t mention R, it does crop up in the first of the comments on his post.

Jérôme also examines a number of online graphics services that were all new to me. Of these, I found Swivel particularly interesting. The site was established in December 2005 (giving it excellent early-mover Web 2.0 credentials) and allows users to easily upload, share and explore data. As an example, I uploaded the Starbucks data from my previous post and here is the chart that Swivel produced.

Outlets
A Turning Point in the Growth of Starbucks?

Seeing me playing around with Swivel, Michael Michael suggested that I produce a chart of the Beijing 2008 Olympic medal tally as it unfolds. I took up the challenge, which was probably rash as I will now feel obliged to keep it up to date. Here are the results so far.

Medal Count by Country
Beijing 2008 Medal Tally

The data itself is here and a chart with the overall medal tally for each country is here.

I will continue to experiment with Swivel, as well as the IBM offering, Many Eyes, so you can expect to see a few more online charts featured here. As a start, following on from an earlier post on declining CD sales in Australia, I have posted ARIA album sales data for CD, cassette, vinyl and digital formats from 2002 to 2007. If you are keen, you can also keep an eye on my Swivel page.

Possibly Related Posts (automatically generated):

13 thoughts on “Online Data and Charts with Swivel

  1. Pingback: Kwoff.com

  2. Pingback: Australian TV Radio Online Coverage 2008 Beijing Olympics - Channel 7 SBS ABC < Rambling Thoughts Blog - Neerav Bhatt

  3. dan

    when you have some time, i would like your thoughts on hyperinflation. specifically how zimbabwe today, compares to weimar germany (and other historic cases of hyperinflation).

    so while you are fiddling with graphing software, perhaps you could bring forward the graph that the nytimes published a couple of years ago:

    http://www.nytimes.com/2006/05/02/world/africa/02zimbabwe.html

    and then add in a line for weimar.

    only if you’ve got time.

    d

  4. Bast

    I notice you haven’t included Canada in your medal count graphic. Oh ….. wait a minute… never mind. [Big, huge sigh and hanging of head in national shame…]

  5. Bast

    Can I just add we are, actually, more of a winter Olympics kind of country…roll on Vancouver 2010!

  6. Pingback: Olympic Medal Count by Population and GDP | A Stubborn Mule's Perspective

Leave a Reply