Population Pyramid by Ethnicity: Gender 1 color

[scioltos]

Hiya,

I've attached what I've been working on

For the last tab, pyramid total, I've generated the formatting of the graph I want. The only problem is the coloring: I don't want each series to be colored differently. Rather, I want the ethnic groups to be colored differently and men and women to be colored the same. In total, the graph should have 4 colors that represent ethnicity, and Chinese males and females would be the same color.

Does anyone know how to do this? Tried fiddling around with it but just can't figure it out

Cheers