I have created a pyramid population that divides the data by gender and by age (I created a bin for age so we can visualize age by segments of 5 years).
If you look at the attached workbook you'll see that the pyramid is created, however, the percentages of total that the pyramid is showing, as well as the bar charts, are independent for males and females.
I would like to show a bar chart and percentages which compare a specific segment to the entire population, not separated by gender (for example, females at the age of forty divided by the total population).
Can anyone help me achieve this?
Thanks!