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:
- 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...
- 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...
- 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,...





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
You got the basic recipe right.