Population pyramid overlapping series question

Hello

I am creating a population pyramid looking at poulation by gender and ethnicity. I can make a standard pyramid with one gender each side and the ethnicities overlapping within the age band similar to a stacked bar chart, however, I was wondering if it is possible to have one overlapping ethnicity series and the others seperated.

What I would like is to have the figure for all ethnicities as one wider overlapping data series and then within that each individual ethnicity displayed seperately as individual bars. Everything I have tried seems to be all overlapping or all seperate, is there a way to have only a few select series overlapping?

Thanks in advance

Rhys

Thanks for the reply Andy

Attached is a dummy table and pyramid with a (very basic) illustration of what I am aiming for. In the mock up example the dark blue bar would be the figure for all ethnicities in the age band and then the green and orange bar would represent white and mixed ethnicites at that age band.

Apologies for the large table, in my head I figured if I had the figure for all ethnicities every other column I could then overlap those to create the large bar with everything seperate within.

Rhys

That's great, exactly what I am looking for. Bit embarassed that I didn't think to swap the 'all' figures over to the primary axis though!

Thanks Andy