The data for a Population Pyramid
Data on a population pyramid is traditionally presented shown against.
Subtraction of a column
Before to create your chart, you must perform a subtraction of one of the columns (women are generally on the left of the graph, so it is this column that will be subtracted).
You write then in a new column the following formula
Copy this formula to all the series of ‘Women’ and also add a title in cell D3.
Choice of the chart
On the menu Insert > Charts, you will choose the chart type ‘Bar‘, then the first sub-menu 2D Bar> Clustered bars.
You get the following chart (wow, it doesn’t look like a population pyramid 😕 )
Remove unnecessary data
We have a chart that has two columns for the women (a positive column and a negative). We will remove the positive column.
Select the chart and select the menu Design > Select Data. The following dialog appears:
You will also have display this dialog box by doing a right click on your chart and choosing ‘Select data …’
In this dialog, you choose the first ‘Women’ and click on Remove. If ever you select the wrong series, do not worry, just click the cancel button and start again.
You can see that in your chart, the bars are thin and offset with respect to each other. It is very easy to remedy these two points.
After selecting the chart in the Layout tab, you select the series Women and then you click Format Selection. You can also right-click on your chart and select the menu Format data series…. The dialog box is displayed.
To reduce the gap between the bars, you will move the cursor to 0% (no gap) and the bars are not offset. Then you move the cursor to 100% (overlapped).
The graph becomes
To complete our graph, we must reverse the vertical-axis so that the lowest values at the bottom, set the horizontal-axis while the left and also change the number format to not display negative values.
Select the vertical axis (using the dropdown menu in the Layout tab is easier) and then you click Format Selection. In the Settings box, you select Axis Options and you select ‘Categories in reverse order’ (to return the chart) and also change the value ‘Axis Labels’ in the Low (to put axis labels on the left).
Then select the horizontal axis.
And the chart becomes :
Change the design
It only remains for you to use the various menus layouts for a very neat pyramid.
The chart becomes
And if you change the color of the format Series (Gradient fill)