This content is password protected. To view it please enter your password below: Password:
A population pyramid is an icon of population studies. To create a population pyramid in Excel you just need population by sex and age groups. Since male population is displayed to the left of the axis, you have to force the data to assume negative values. After that, the x-axis is formatted to remove the minus sign.
In population studies, we can learn a lot about the population by measuring the relative proportions of each age group (Young, Adult and Old). In the demographic dashboard, we'll use these ratios as our KPI's, and we'll compare the current country to the active region. We'll have two pivot tables, one for the country and the other for the region.
We'll see how to change a pivot table from absolute values to proportions, how to use a base field and item to make new calculations, how to make a dynamic chart using dynamic ranges and ranges that point to different data sources depending on user selections.
In this module we'll see how to setup the data source for a scatterplot and split it into three series.