Creating a Population Pyramid in Excel, Study notes of MS Microsoft Excel skills

Download Creating a Population Pyramid in Excel and more Study notes MS Microsoft Excel skills in PDF only on Docsity! How to plot population pyramids in Excel Population pyramids are back-to-back horizontal histograms. First need a frequency table with the population split into age group and gender. These frequencies are then expressed as percentages of the total population by gender. If percentages are not calculated beforehand use EXCEL to do this. The formulae for Excel are given below. The percentages for males are negative so when the graph is plotted the columns for males will be plotted on the left hand side of zero on the horizantal axis. Add 2D clustered bar graph. Select A1:A12 hold down the Ctrl key select D1:E12 select the Insert tab then Bar and Clustered Bar -20.00 -10.00 0.00 10.00 20.00 0-9 10-19 20-29 30-39 40-49 50-59 60-69 70-79 80-89 90-99 100-109 Percentage Male Percentage Female Close the gaps between bars and add borders. Right click on a bar Select Format Data Series Drag slider for Series Overlap to 100 % Drag slider for Gap Width to 0 % Select Border Color then Solid line select the Color Click on the columns on the other side and add a border in the same way and Close Add a title and vertical axis label. Click on the graph select the Layout tab then Chart Title then Above Chart type Population Pyramid for Torbay 2011 and Enter Select Axis Titles then Primary Vertical Axis Title then Horizontal Title type Age and Enter then drag the title to the top of the vertical axis Delete grid lines. Right click on a grid line and Delete Move legend. Right click on the legend select Format Legend then Bottom and Close