The Daily Graph  -  Charts in Excel

"The Daily Graph" re-creates charts from The Economist's Graphic Detail blog using standard run-of-the-mill Excel techniques without macros. We do try to milk Excel for all it's worth and apply techniques that may not have been intended in the way we use them. In the end, it's the result that counts.

"The Daily Graph" is published whenever we spot an interesting chart on The Economists's blog that looks like it cannot be done in Excel. Typically once or twice a week if we can find the time.The Daily Graph blog comes with a dowloadable version of an Excel workbook so that you can follow what we did... or you can "borrow" our work and use it for something entirely different.

"The Economist" is a trademark of The Economist Newspaper Limited´╗┐. "Excel" and "Microsoft" are trademarks of Microsoft Corporation". See http://www.economist.com/blogs/graphicdetail´╗┐ for more information on the "Graphic Detail" blog from The Economist. All charts on this page and on the blog-pages are entirely made in Excel and not copied from anywhere. We used Excel 2007 until April 2013, Excel 2010 until September and are now on Excel 2013.

New victims

 
Apptrac | The Daily Graph: New victims

[Feb 13, 2014]   At its heart, the Stacked Bar chart today is nearly identical to the chart we did on January 23 . We fiddled with the data and the maximum and minimum for the horizontal axis and were basically done. But... the labels for the horizontal axis...

 

Abortions and births

 
Apptrac | The Daily Graph: Abortions and births

[Feb 5, 2014]   We did a chart that was nearly identical to this one in January of last year (click here ). At that time, the chart plotted dead rate v. abortions. At least, The Economist found a less gloomy way of depicting the same. Last year we had...

 

Taking the king's coin

 
Apptrac | The Daily Graph: Taking the king's coin

[Jan 23, 2014]   We have a new trick for you in today's Stacked Bar chart. Excel doesn't let you vary the width between stacked bars so we need to help it a bit. We do that by stretching the categories. In this chart, each category is stretched nine-fold....

 

And God created...

 
Apptrac | The Daily Graph: And God created...

[Jan 7, 2014]   Happy New Year... and sorry for the long wait since the last blog but we were busy working for our customers. The Economist kicked off the year with a rather simple Bar chart that they nicked one-for-one from the Pew Research Institute. In our...

 

Catching the eagle

 
Apptrac | The Daily Graph: Catching the eagle

[Nov 22, 2013]   The chart today is nearly an exact copy of a chart that The Economist did in early June: same subject, nearly the same design. Therefore - for once - the rest of today's blog is simply the text from our blog from early June. The the chart and...

 

Bringing home the Bacon

 
Apptrac | The Daily Graph: Bringing home the Bacon

[Nov 15, 2013]   This seems to be The Economist's favorite chart type because they do them so then. We have done similar charts in June and March but this one is slightly different. We took the Pay in Europe chart from 11 June as a starting point. That one was...

 

Payback time for subprime

 
Apptrac | The Daily Graph: Payback time for subprime

[Oct 24, 2013]   This is for once a Stacked Column chart that comes almost from out-of-the-box-Excel... with two small twists: There are apparently some extra labels for the first two columns; and the order of series in the legend is reversed, compared to what...

 

Waiting for work

 
Apptrac | The Daily Graph: Waiting for work

[Oct 23, 2013]   We have done this type of maltreated Bar-or-is-it-Line chart before using Excel's Scatter chart functionality. This time we opted for a plain Bar chart with pictures for the formatting of the bars and the markers. The pictures are included in the...

 

Just do it

 
Apptrac | The Daily Graph: Just do it

[Oct 7, 2013]   This Bar chart is quite similar to the chart that The Economist did on April 2nd. Yesterday's chart was also a reheated version... it makes one wonder if the usual editor at The Economist is on leave and they have put an intern in charge....

 

Give it back!

 
Apptrac | The Daily Graph: Give it back!

[Oct 2, 2013]   This Bar chart is nearly an exact copy of the main part of chart on non-selling cars we did the other day. We added a few data-series to account for the additional categories and had to set different limits on the horizontal axis. To polish it...

 

How to contact us

+49 (0)204 1348 4565

Or leave us your number and we will call back shortly

And you can reach us by email

         Email