8 Replies Latest reply on Dec 8, 2016 5:57 PM by Yuri Fal

Creating stacked bar graph with value of the first measure as base value for the second

Values of the second measure can be negative as well and are colour coded accordingly. Kindly help create this!

• 1. Re: Creating stacked bar graph with value of the first measure as base value for the second

Hi Silajeet.

workbook (version 9.3) attached for your reference. Let us know If you've any query.

Mahfooj

• 2. Re: Creating stacked bar graph with value of the first measure as base value for the second

Hi Mahfooj,

Thank you for the reply, but the graph I want differs in the sense that one of the bars should start from the top of the other graph and be populated in accordance to the values being positive or negative. In your graph both the bars has y=0 as the base, which is not the case with one of the bars in the image I posted!

• 3. Re: Creating stacked bar graph with value of the first measure as base value for the second

Is that what you wanted?

• 4. Re: Creating stacked bar graph with value of the first measure as base value for the second

Almost! Bars with the negative values (in your case, the red ones) should come down from the top of the respective blue bars, instead of going up from there, and I will have what I need

• 5. Re: Creating stacked bar graph with value of the first measure as base value for the second

I've some other engagements today so wont be able to give you more time in this. I hope someone from the forum will definitely try.

Mahfooj

• 6. Re: Creating stacked bar graph with value of the first measure as base value for the second

Thank you for your time! Would appreciate if you look into this whenever you are free.

• 7. Re: Creating stacked bar graph with value of the first measure as base value for the second

Hey Silajeet,

It sounds to me that you are looking for a waterfall chart:

If that's the case, just check out this link on how to make it. It's really easy!

Hope this helps!

Cheers,

Matthias

• 8. Re: Creating stacked bar graph with value of the first measure as base value for the second

Hi Silajeet,

Please try to learn from the workbook supplied by Mahfooj.

Sure you could be able to modify the view to get what you want.

Yours,

Yuri

BTW, it looks like someone is cross-posting:

Overlapping of Graphs

May I ask you what is the real purpose of the question asked?