This blog is available in English only.

The Daily Graph
Toil and trouble

0 Comment
2013-07-16 22:01:56
 

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 /07/daily-chart-13

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 top chart today is nearly an exact copy of the Column chart we did on June 26th*. We only put this one in because The Economist got it wrong. If you look carefully  at the chart The Economist put on its blog, you'll notice that the values for the brownish-red line do not agree with the sum of the column values. So, for the few lost souls who take these things seriously: here's a correct version of what The Economist intended.

The bottom chart is the Bar version of the top chart. Copy the top chart, change the chart type and fiddle around with the data and data-labels a bit. That's all there is to it.

 

* Have a look here if you want to know more about preparing a chart like this.

The stats:

Our assessment of the difficulty of the chart: 5 (out of 10)

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

Time it took us to create the chart: 7 and 9 minutes (top and bottom separately)





 
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