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?
Xiao, I see what you are trying to do. I don't know how to get there.