3 Replies Latest reply on Sep 7, 2017 6:22 AM by Ray Givler

# How do you split the grand totals into two genders and make them not stacked on one another?

Hey guys,

See below my original table. I have divided my table into six regions/two genders (male-blue and female-red).

When I convert the table into a bar graph, the totals stack onto one another, like this:

I would prefer the total has a similar format as my other six regions though...

I'd like the two bars stand side by side like others do. I know there's something wrong with the grand total; maybe I should calculate subtotals based on gender? But how do you do that?

Thank you so much!

• ###### 1. Re: How do you split the grand totals into two genders and make them not stacked on one another?

Try the link below. These graphs are nice for gender (or any binary) breakdowns:

• ###### 2. Re: How do you split the grand totals into two genders and make them not stacked on one another?

Hey Ray,

Thanks for the link, but I am not trying to create a population pyramid. I am satisfied with the bar charts except the grand total section. I'd like to break that total into two columns: one male and one female. Right now the total section has one column stacked with two genders shown in different colors. Do you mind shedding some light on this?

Thanks!

• ###### 3. Re: How do you split the grand totals into two genders and make them not stacked on one another?

Xiao, I see what you are trying to do. I don't know how to get there.