How to do a side-by-side waterfall chart with multiple data series

[trippknightly]

I want to show two waterfalls where all the change components from two different years are right next to each other for comparative ease. This might require doing a waterfall the old-school way and not use the waterfall chart type (given its limitations).

I know how to do, say, a waterfall for 2022 and then right in it further to the right is the 2023 waterfall. But then my change components (hires, attritors, transfers) are not right next to each other.

 

[awoohaw]

probably need to provide some sample data. What do hires, attritors and transfers do in the data? Is there are starting number?

 

[trippknightly]

So in below example, I want to show to show 5 pairs of columns in water fall format depicting how each year's employee count changed due to hires/departures/transfers so said another way two pairs of employee total columns on either end, with three pairs of "change" contributors in between.

Americas Division Employee Changes 2022 through 2023
2022: 2023:
Starting Employees 2300 2415
Hires 220 130
Departures -150 -195
Transfers 45 -25
Ending Employees 2415 2325

 

[awoohaw]

I'm not sure where you want the dynamics. The only thing that is tricky is the last column data needs to be labeled as a total column.

Configuring the last column data point:

 

[trippknightly]

Thx, I appreciate the effort but keep in mind I don't want two side-by-side waterfalls but rather side-by-side data columns for each category. Each of those x-axis labels would have two columns (one for ea year, the 2022 columns will end up being just for backdrop / context and I'd likely de-emphasize through hashing or lighter color scale. So in the end it will be a single bar chart (with two waterfalls therein) not two separate waterfall charts.

 

[awoohaw]

Sounds like you need to use a combination of stacked columns and clustered columns which I don't think is a combo chart option. Maybe someone else will come up with a solution for you.