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 ShareI 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 ShareI’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 ShareOn 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.

trust

How to trust an Excel VBA application?

Share A trust worthy person should be: 1. Honest & true. 2. The person is honest and true in many different situations. 3.The person is honest and true over a long period of time. Trusting an Excel VBA application is like trusting a person. When you trust a person, you have an expectation that this [...]

Continue Reading

Just as I was about to get used to Excel 2010. Now the game changed again!

Office 15, Word 15, Excel 15 & PowerPoint 15 screenshots.

ShareIt didn’t seem too long ago that Microsoft released Office 2010 (Office 14) upon us. Continuing the Windows 8 momentum we soon will hear about Office version 15! Here’s what going to happen. According to a Bloomberg report, Microsoft plans to finish up all work on Windows 8 by summer 2012 and release the new [...]

Continue Reading

Connect with us on Social Media

Twitter
Discussion forum, directions to office, new ideas, discounts and offers.

Any questions?

  1. (valid email required)
  2. (required)