BP Oil Spill shown in a Microsoft Excel Chart

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.
Vessel Oil Tanker

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:

This chart applies the “Lollipop Approach”. Dates are easily associated with the stock price and events of the BP oil spill.

reference: http://en.wikipedia.org/wiki/Deepwater_Horizon_oil_spill.

About Aeternus Consulting

Related Link: Aeternus Consulting Excel Training Courses Singapore

Aeternus Consulting offers an excellent workshop Storytelling with Data Visualization using Beautiful Excel Charts. This workshop is aimed at students visualizing thesis data, managers and analysts needing to communicate in a data-driven way and leaders informing their board to drive actions.

Related Link: Making Charts Beautiful with Microsoft Excel

excel courses in singapore
Advanced Excel Training Courses Classes Singapore: making beautiful charts

2 Responses

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *