Dashboard ideas from Wall Street Journal

Posted by 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. Lollipop approach to clarify Microsoft Excel line charts Traditional Microsoft Excel line charts have a common problem. It is hard to visually associate the data points with the horizontal axis. The traditional axis...
  2. A magazine quality chart in Excel I know the idea of creating beautiful charts in Excel seems unfamiliar, but I assure you Excel is a very capable platform to do so....
  3. Excel Line Charts with Elegant Dates 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...

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!

android-10b-excel

Google officially announces 10 billion app downloads in Excel

Dec 08, 2011 | Discuss

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

Sep 11, 2011 | Discuss

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