Combined Stacked Bar & Waterfall

[hb66Participant]

I cant work out a simple, quick and repeatable method for creating this type of graph. Has anyone seen this done?

[dgteamModerator]

Here is an example of a bar + waterfall using a similar setup as your data. This uses a Bars command for the stacked bars, and a Bar command for the waterfall.

We uploaded this file to the Custom graphs so you can see the details. Go to File > On-line examples.

Note we created a column that does a cumulative sum from the starting value (34) and using each of the Delta values from the waterfall. The result is that the beginning of the stacked bars do not exactly match the sum of the values in the stacked bar.

For example for the second stacked bar the delta values would give a value of 32.2 but the values in the table add up to 33.

Should these values match? Or perhaps the values used in the stacked bars are rounded to the nearest integer in the screen shot you sent.

In any case hopefully this helps and if you have a table that has raw data used to calculate the change that goes into the waterfall, we could look into creating an example that does those calculations too.

[hb66Participant]

Thanks very much for the reply. Will explore this over the weekend – great product great service and support!

[Author]

Posts