I formatted the second two series to plot on the secondary axis, then changed their chart type to stacked column
I added a dummy blank series to the first axis for spacing
I adjusted the gap width of the series until they spaced properly
Then I adjusted the axis scales so they both matched each other and finally deleted the legend entry for the dummy series

as best I remember ;-)