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: