A New York Times Chart in Excel

I was surfing the web and came across this chart from the New York Times. My attention was totally captivated by this intricate chart. It says that healthy food are getting more expensive while junk foods are getting cheaper! What’s noteworthy about this chart is that the designer didn’t simply just plot the line charts. That’s way too easy and lazy.

Instead, he added detailed titles, notes and foot notes around the chart. He used great colour combinations to make the individual line charts appear calm & coordinated. He highlighted the individual data series to add clarity. And he did all this within a few inches of space! The result is a compact chart that tells a reader so much an entire article was brought to life by this tiny picture.

I wondered how many of us out there pay so much attention and effort to our charts? You probably say “I don’t do this because its not worth the trouble”. Well, you missed out a perfect chance to be remarkable to your colleagues and management. You say “Its impossible to do this chart.” Here’s one I did in Excel 2003:

You say “I don’t know how”. We’ll teach you here.

Any more excuses not to be great?

To learn more about how to create beautiful charts like these in Excel, check out this workshop: Beautiful Excel Charts

Related posts:

  1. A Straits Times chart in Microsoft Excel I came across a stock maket chart in Straits Times a couple of days ago. Just for the fun of it, I create one in...
  2. A crappy chart from the Straits Times. GIC looking to Asia, emerging markets I’m going to take a potshot at the Straits Times on a chart I saw in the Money Section. The chart was trying to compare...
  3. BP Oil Spill shown in a Microsoft Excel Chart On 20 April 2010, a BP oil well exploded in the Gulf of Mexico, causing the largest offshore spill in U.S. history. This Microsoft Excel...

Comments are closed.

android-10b-excel

Google officially announces 10 billion app downloads in Excel

As an Android fan, I am happy to learn that the Android Market has surpassed 10 billion downloads. I found this pretty looking 3D column chart. I have never been convinced that 3D charts are good enough for serious business use. But this chart made me think again. The exponential growth trend jumped at me. [...]

Continue Reading

3D Setting in Excel Charts

Do it in Excel: Ring charts are better Pie charts

Pie charts are a circular chart divided into sectors, illustrating proportion. I remembered learning them when I was in primary school. Apparently it was invented by this person called William Playfair in 1801. Pie charts are simple to understand but rather limited because: 1. Can only show a single data series. 2. Can only show [...]

Continue Reading