Dashboard ideas from Wall Street Journal

Posted by CH Leong on Sunday, December 14, 2008 · Leave a Comment 

The Wall Street Journal have a lot of good looking charts which I draw my dashboard ideas. You can hardly find any in BusinessWeek or Fortune nowadays.  The chart from WSJ below shows a complex story of European bank revenues from equity capital markets deals(ECM).

Chart from WSJ

Chart from WSJ

To create such a chart in Excel, I placed a stacked column chart on Excel’s primary axis and a line chart on the secondary axis.  To replicate the exact look, I applied more chart formatting tricks.  The result is largely faithful to the original. I am trying to demostrate Excel’s capability to produce professional looking charts and dashboards.

WSJ chart in Excel

WSJ chart in Excel

Related posts:

  1. More Dashboard examples I know the idea of creating dashboards in Excel seems...
  2. What is a bullet chart? A bullet chart is a relatively new kind of chart...

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


beautiful-dates-in-chart

Elegant Dates in Line Charts

Aug 29, 2010 | Discuss

I came across this stock chart in the Kuala Lumpur’s edition of the Business Times while I was in Malaysia. The chart has an elegant treatment of dates. I have seen this sort of designs in many magazines and wanted an afternoon challenge to do this in Excel. The exercise wasn’t very challenging after all. [...]

Continue Reading