Although Excel does not have a built-in population pyramid chart type it can be done...
Create a population pyramid from this data:
|Age Group (years)||Males(%)||Females(%)|
Enter the data into Excel.
Note: We have to enter the first data series as negative numbers.
Select the data and start the Chart Wizard.
Select 'Bar' as the chart type and 'Stacked Bar' as the sub-type. Click on the sample button; it should already look a bit like a population pyramid. Click 'Finish' and admire your chart:
We don't want gaps between the bars, so double click on one of the bars on the left to bring up the 'Format Data Series' control.
Go to the 'Options' tab and reduce the gap width to 0. Go to the 'Patterns' tab to change the bar colour. Click 'OK' to see your changes.
We don't want the bottom scale to show as negative numbers. Double click on one of the numbers on the bottom scale, go to the 'Number' tab. Reduce the 'Decimal Places' to 0 and select 'Number' as the category and the red '1234' for negative numbers.
Some more tweaking and your chart is done: