Population Pyramid by Ethnicity: Gender 1 color

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

Hi Scioltos,

You have to change it manually by selecting the every series.

Thanks Nisha

Thanks for the response -- How would I go about doing that then?