Demographic chart

Demographic data are typically shown as a graph wit Women and Men on either side of a central, vertical axis, and with age distribution along this axis.

An example here:

This chart has been made in TARGIT, even though TARGIT does not have a chart type called 'Demographic chart'. The chart type used, is the 'Bar chart' with a couple of necessary custom settings.

The original data (source: Statistics Denmark) looks like this when pulled into a table in TARGIT:

• First, I will create two calculated columns that will copy the Men and Women data. However, with the Men data as negative numbers:
  • Men: -sum(d1, 0, m1)
  • Women: sum(d2, 0, m1)

• Then, I will use the 'Visibility' option to hide the original measure, so only my two calculated columns are visible.

• Next, I will change the object type to a 'Bar chart' and make sure that the bar stacking is set to 'Back to back'.

• Furthermore, I want my measure axis (at the bottom of the graph) to show positive numbers in both directions. This is done in number formatting (the # icon) in the Measure axis settings, where I remove the "-" in front of the negative numbers.

• The same type of number formatting may be applied to Mouse over labels as well, so that values on Men (and Women) always show up as positive numbers.

• To revert the sort order (0 years at bottom, 99 years or older at top), we should introduce another calculated column.

allcount(d1, d1:0(u), m1)

• When you do sorting on this column (and afterwards hide it via the Visibility options), yuo can eventually achieve this result: