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 line chart illustrates some key events 2 months after the explosion and BP’s stock price using a common Date horizontal axis.

The resulting chart is rich in information yet it’s not cluttered. The key relationship between stock price, event and dates are tied up using the “Lollipop Approach” described earlier.

See the full pic: BP oil spill infographic in Excel (full resolution: 792x448).

references: http://en.wikipedia.org/wiki/Deepwater_Horizon_oil_spill. http://www.ft.com.

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

Related posts:

  1. Singapore General Election Results 2011 Microsoft Excel Chart-Part2 This is an alternative interpretation of my previous Excel chart on the 2011 Singapore General Election results by James C Lee. Below was my original...
  2. 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...
  3. Your own American Deficit/Debt Chart in Microsoft Excel In the United States Congress there are currently a number of disagreements between Democrats and Republicans regarding the United States debt. On August 2, 2011,...

Comments

2 Responses to “BP Oil Spill shown in a Microsoft Excel Chart”
  1. AusSteelMan says:

    Nice indeed.

    I am assuming a 2 series stacked line chart, or I suppose it could be 2 series line chart with the comment series as the first series so that the second series is then “on top”, hence the error bars being solid only.

    I am also guessing the event labels are the data series showing “Label” or the use of the a chart labeler add-in

    thanks,
    ASM

  2. CH Leong says:

    You got the basic recipe right.

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

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