How do I create an Exploded Bar Chart?

Posted on 2012-08-20
Last Modified: 2012-08-20
I came across this graph in today's newspaper (publicly available data):Exploded bar chart
The green items add to the blue base amount cumulative running total and the red items subtract from it, resulting in the end cumulative blue bar.

How do I create such an Exploded Bar Chart in either Microsoft Excel, Apple Numbers or other software?
Question by:ShanghaiD
    LVL 8

    Accepted Solution

    I think you are referring to Waterfall or Bridge Chart.

    Check these out:

    Open in new window

    Open in new window


    Author Closing Comment

    Excellent!  Exactly what I am looking for!

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now