This blog is available in English only.

The Daily Graph
A job for life

0 Comment
2013-02-15 13:57:51
 

The Economist newspaper publishes a fancy daily chart on its blog. In our blog we replicate the chart using standard run-of-the-mill Excel techniques. Usually we get close, sometimes it's more difficult.

   More posts...  

Here's the link to today's Economist chart:
www.economist.com/blogs/graphicdetail/2013 /02/daily-chart-5

The main tricks for creating the chart in Excel are revealed further down in this blog. You can view all the ins-and-outs by downloading the Excel workbook. Use the workbook as you like: copy, change and/or distribute it -- we are pleased when you are.

Download the Excel workbook Free Download
 

This is what it looks like in Excel

The Daily Graph

Tricks for creating the chart in Excel

The Time in office chart for all popes got many comments at The Economist's website. The gist of many comments was that there was just too much information to be displayed in a satisfactorily manner. We toyed around with the chart a bit to enhance it but gave up initially. The problem we struggled with is that there are simply too many popes (and hence: columns) to be shown as a picture on a website. Pretty soon, pixels start disappearing and everything becomes a bit of a blur (see this Excel workbook if you're interested in our not-so-successful attempt).

Inspiration came over lunch today. We think we found an acceptable and somewhat appealing way to condense the information so that it can be shown as a chart. For once we're not elaborating on how we did it, just look at the Excel workbook if you want to know: it's all rather straightforward if you can follow how we rearranged the data. 

The stats:

Our assessment of the difficulty of the chart: 8½ (out of 10)

Usefulness of the chart for other purposes: 4 (out of 10)

Time it took us to create the chart: Outside competition (but way too long, frankly)



 



 
0 Comment

Send a comment

  

Send

 

So erreichen Sie uns

+49 (0)204 1348 4565

Wenn Sie Ihre Telefon-Nummer hinterlassen, rufen wir gerne Zurück.

Oder kontaktieren Sie uns per Email

         Email