Thread: Combination stacked and column chart

I can't seem to make this chart work on the attached sheet. I would like the Work hours as a column on the primary axis. I would like the people needed as a column on the secondary axis. finally I would like the people on ahnd and the fill ins as a stacked column on the secondary axis. Will this work?

To get the described chart you need to change you data layout.

Move the last 3 series to the secondary axis.
Change chart type to stacked column.

For all series decrease gap width to zero.