How to Create Population Pyramid Chart in Excel?

  1. Take sample data. Here we take 2 more columns for supporting calculation.

Population Pyramid Chart

 

2. To create Male %, give the below formula and copy it down to the column. Use the =C2/$C$23 formula for Female %.

Population Pyramid Chart

 

3. Select any cell of data then go to the ribbon, select Insert, and select your chart type from the chart group.

Population Pyramid Chart

 

4. Select Chart type as 2-D Bar.

Population Pyramid Chart

 

5. The chart looks below.

Population Pyramid Chart

 

6. To change the category in reverse on the vertical axis, right-click on the axis and select Format Axis.

Population Pyramid Chart

 

7. After that in the Axis Options give a checkmark on the ‘Categories in Reverse Order’ box.

Population Pyramid Chart

 

8. To change the axis label position, right-click on the Axis and select Format Axis, in Format Axis select Axis Option and choose Labels. Here click Low in the Label Position.

Population Pyramid Chart

 

9. To remove the horizontal axis, click on Axis and press Delete.

Population Pyramid Chart

Population Pyramid Chart

 

10. To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.

Population Pyramid Chart

 

11. To change the gap width in the bar, right-click on the chart and select Format Data, in Format Data Series select Series Option and change the gap width to 0%.

Population Pyramid Chart

 

12. Now we give a white outline in the bar to distinguish one bar from another. Select the bar, go to Format ribbon, and choose shape outline as white.

Population Pyramid Chart

 

13. To change the color, select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.

Population Pyramid Chart

 

14. Follow the same step to change the color of the other part of the chart. Select the bar, go to Format in the ribbon, click Shape Fill, and choose your color.

Population Pyramid Chart

 

15. Select the chart Title and write your appropriate Title.

Population Pyramid Chart

 

16. The chart looks below.

Population Pyramid Chart

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories