How to Make an Age Pyramid on Excel


You can use Microsoft Excel to make a variety of charts with the interplay of data and images. One of these is an age pyramid, which you can make to graphically show the span of ages in a cohort, class or work group. Excel offers a choice of several different pyramid styles. You can also change the colors of each pyramid to further signify different ages or age groups.

  • Tally the ages of the people in your group. For example, if you want to make a graphical representation of your work group, you could use these categories: "20-30," "40-50," and "60 and above." Ask every person in your group which age range she falls in and make a tally mark next to that category.

  • Enter the number of people in each age category in the function box, labeled fx. For example, type "5." It will appear in box A1. Type "6" in the fx box. It will appear in A2, and so on.

  • Click on the A1 box. Press "Ctrl + A." Click "Insert."

  • Click the "Bar" icon. Click the "Pyramid" icon. A pyramid chart reflecting the number of people in each age pyramid will appear. You will have three pyramids representing ages 20-30, 40-50 and 60-75.


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!