Population Pyramid Chart

Application Scenario

The population pyramid can vividly display the number and proportion of people of different ages in the total population, indicating the type of population age composition and the population situation. The population pyramid chart can display the past population situation, the current population structure, and the possible trends in population.

Function Description

The document introduces how to use FineBI to create a population pyramid. The following figure shows the effect.

Data Preparation

1. Log in to the system as the admin, click My Analysis, click a folder, and click New Subject.

2. Click Local Excel and click Upload Data, as shown in the following figure. You can download the sample data: Demographic Table.xls.

3. After the upload, click OK.

The data table counts the population by age and gender, but it is not convenient for data analysis. In this context, data processing is required to restructure the data table with three fields: age, gender, and population.

Data Processing

1. Add the Column to Row step, click Select All, and deselect Gender.

2. Rename the converted fields Age and Population respectively.

3. Click Save and Update.

Chart Creation

1. Click Component and copy the Population field in the to-be-analyzed indicator area.

2. Rename the added fields Male Population and Female Population respectively, click Filter Detail, and set the condition that Gender is Male and that Gender is Female respectively.

3. Drag the Age field into Vertical Axis and the Male Population and Female Population fields into Horizontal Axis, and click the Contrast Column Chart icon in Chart Type.

Style Adjustment

The male and female populations are grouped by age in the chart preview area. You can also adjust the display color based on gender by dragging the Gender field into Color in Graphic Property.

You can adjust the display color and set the age displayed in order on the vertical axis as needed.

Click Set Value Axis and set the maximum value for the Female Population and Male Population indicators separately to unify the scales of the left and right axes.

Drag the Population field into Label.

Effect Display

The following figure shows the final display effect.