Waterfall showing incremental ranges

[Garuda]

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

 

[chirayu]

Something like this?

 

[Vivek D]

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.