This one is a fine sample spreadsheet to construct a population pyramid in excel sheet, user have to fill in data in % divided into males and females along with their age.After the data input chart will be automatically constructed in the same sheet but in different tab provided.

population pyramid excel sample
Easy to understand and use and understand.

If you have data of actual males and females instead of percent you  can arrange the data according to this tutorial.It is quite easy to edit this sheet and make it usable. Try this tut