Waterfall and Stacked Bar

[#1]

Good Morning -  I'm trying to create a stacked bar embedded in a waterfall chart?  I know how to do the waterfall but not sure how to get the pieces to show in a stacked bar format, if it's even possible. Similar to this....don't care about the percentage bubbles....thanks for your help/time.

-Michael

[whiteline · Accepted solution]

Hi.

First create simple stacked bar chart without offsets splitting the bars into Direct and Indirect (additional dimention).

Then modify the offset expression to be applied only once for each bar (i.e. only for Indirect).