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.
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.
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.