• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Waterfall showing incremental ranges

Garuda

New Member
Hi all,

I am trying to create a waterfall chart. However, instead of showing the incremental change, i want to show a range for each step-up.

For example.

Baseline column is 100
Next value is an increase in the range of 5 - 15.
Next value is an increase in the range of 10 - 20.

So, I am trying to recreate a waterfall showing 100, the range of 5-15 (midpoint is 10) on top of the 100, the second value range of 10-20 (midpoint is 15) starting at 110 (100+10). This will give me a final column of 125.

Any ideas on how to do this? I am trying the candle stick chart, but not very successful and as usual have a tight deadline for this!

Appreciate any help.

Regards,
Garuda
 
I recently created a waterfall chart for one of my requirements. See if it is helpful.

The data needs to be prepared using formulas on your base data.

If you can upload a sample with your data set, I can try to help out better.
 

Attachments

  • Waterfall Chart.xlsx
    35.4 KB · Views: 25
Back
Top