This blog is available in English only.

The Daily Graph
Football wealth

0 Comment
2013-01-26 20:06:09
 

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 /01/focus-4

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

Our fastest chart ever! This chart is almost an exact copy of the chart on Value-added trade that appeared in our blog and that of the Economist on January 19 (see www.apptrac.net/en/blog/the-daily-graph/19-value-added-trade.html and www.economist.com/blogs/graphicdetail/2013 /01/focus-2, respectively). It shows the power of having a portfolio of re-usable charts: we copied the chart from January 19, added a single data series and fiddled a bit with the minimum and maximum values of the horizontal axis. Less than 5 minutes work for a "new" chart. Have a look at our post in the link above to read about the technicalities of creating the chart in Excel 2007.

The stats:

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

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

Time it took us to create the chart: 4½  minutes



 
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