{"id":1986,"date":"2019-03-10T10:16:13","date_gmt":"2019-03-10T10:16:13","guid":{"rendered":"https:\/\/help.instantatlas.com\/?p=1986"},"modified":"2019-03-10T10:16:13","modified_gmt":"2019-03-10T10:16:13","slug":"stacking-population-data-in-bar-charts","status":"publish","type":"post","link":"https:\/\/help.reports.esriuk.com\/report-builder\/2019\/03\/10\/stacking-population-data-in-bar-charts\/","title":{"rendered":"Stacking population data in bar charts with Report Builder"},"content":{"rendered":"

This article will try and show you some of the different ways you can use InstantAtlas Report Builder and the bar chart widget<\/a> to present population data. We’re going to produce a few different charts, but we’re aiming for something like this:<\/p>\n

\"5
5 year age bands, male and female chart with indicators grouped together<\/figcaption><\/figure>\n

<\/p>\n

All of the examples in this post can be seen in the report at\u00a0https:\/\/reports.instantatlas.com\/report\/view\/0fcd2388dcb3401b86657a93f743b145\/E07000200<\/a><\/p>\n

The InstantAtlas national data service<\/a> provides a wealth of data to help you create reports, dashboards and profiles for your areas of interest. However, with so much data available, presenting these data in a clear and informative way without overwhelming your audience can be tricky.<\/p>\n

A common way to visualise population data is by using age bands<\/strong>. The two bar charts below show 5 year age bands for males and females in St Edmundsbury district, Suffolk.<\/p>\n

\"5
5 year age bands, males, as a percentage of total male population<\/figcaption><\/figure>\n
\"5
5 year age bands, females, as a percentage of total female population<\/figcaption><\/figure>\n

This is one way to look at the data, but it doesn’t make it very easy to see how much each age band contributes to the whole population. For that we can start to use stacked bar charts<\/strong>:<\/p>\n

\"5
5 year age bands, females, stacked as a percentage of total female population<\/figcaption><\/figure>\n

So how do we do that in Report Builder? When editing your report, you need to change the following settings<\/a>:<\/p>\n\n\n\n\n\n\n\n
Setting<\/th>\nValue<\/th>\nWhy?<\/th>\n<\/tr>\n
X Axis Label Format<\/td>\n#NAME<\/td>\nMakes the X axis have a simple label of the name of your current feature\/area<\/td>\n<\/tr>\n
Bar Orientation<\/td>\nHorizontal<\/td>\nNot essential, vertical works too, but horizontal often looks better with data like these…<\/td>\n<\/tr>\n
Use Stacked Bars<\/td>\nTrue (or “On”)<\/td>\n<\/td>\n<\/tr>\n
Binding Style<\/td>\nIndicators As Series<\/td>\nSwitches the way data are assigned to either the series or the axis of the chart<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

(Another way of looking at population age bands could be to use a pie chart<\/a>, but that’s a discussion for another time).<\/p>\n

This sort of chart can be great for presenting age bands, but what if we want to compare male and females values in the same chart? What about if we just add all of the indicators <\/i><\/a>? The chart below shows our “first attempt”:<\/p>\n

\"5
5 year age bands, both male and female, stacked<\/figcaption><\/figure>\n

Not very good. Too many “slices”, too few colours and almost impossible to compare the same age bands between male and female. To solve this we have to go into the Advanced<\/strong> settings <\/i><\/a> of Report Builder and start grouping<\/strong> the indicators together and using indicator aliases<\/strong> to control what is shown in the legend and on the X axis. A few settings later and we get:<\/p>\n

\"5
5 year age bands, male and female chart with indicators grouped together<\/figcaption><\/figure>\n

To achieve this, we need to change a few settings.<\/i><\/a>\u00a0First, we alias the indicator names so that the chart \u201cknows\u201d they represent the same thing, just for different groups. So, using the indicator alias dialog, we change all the indicator names to a shortened version:<\/p>\n\n\n\n\n\n\n\n
Indicator<\/th>\nAlias<\/th>\n<\/tr>\n<\/thead>\n
\n
0 – 4 %<\/td>\n<\/tr>\n
0 – 4 %<\/td>\n<\/tr>\n
…and so on for all the indicators…<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Now the chart can provide a common legend for all the\u00a0\u201cslices\u201d in the chart. It also recognises that there are now\u00a0repeating series<\/em>, so it splits the stacked bars into two groups. The final step is to rename those groups and be specific about which group a series belongs to:<\/p>\n\n\n\n\n
Setting<\/th>\nValue<\/th>\nWhy?<\/th>\n<\/tr>\n
Group Series By Names<\/span><\/td>\n&Males=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18
\n&Females=19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36<\/td>\n		Labels each group on the X axis<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

(This is an Advanced<\/strong> setting, so you need to toggle those settings on<\/strong> in the dialog)<\/p>\n

\"\"<\/p>\n

The &Males<\/strong> and &Females<\/strong> control both the labels and which indicators are in which groups (note that the. The values (=1,2,3,4…<\/em>) are simply the indices of the indicators in the alias list – in this case they are very simple because the data is organised so that all the male indicators come first, then the females. You can flip the groups around or move indicators between groups by changing the index values.<\/p>\n

You can open this report in edit mode with this URL:\u00a0https:\/\/reports.instantatlas.com\/report\/edit\/0fcd2388dcb3401b86657a93f743b145?clear=true<\/a> – all the data is shared with everyone.<\/p>\n","protected":false},"excerpt":{"rendered":"

This article will try and show you some of the different ways you can use InstantAtlas Report Builder and the bar chart widget to present population data. We’re going to produce a few different charts, but we’re aiming for something like this:<\/p>\n","protected":false},"author":61,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,55,61],"tags":[56,57,59,60],"class_list":["post-1986","post","type-post","status-publish","format-standard","hentry","category-national-data-services","category-report-builder","category-tips-and-tricks","tag-bar-chart","tag-chart","tag-population","tag-stack","entry"],"_links":{"self":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/posts\/1986","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/users\/61"}],"replies":[{"embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/comments?post=1986"}],"version-history":[{"count":0,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/posts\/1986\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/media?parent=1986"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/categories?post=1986"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.reports.esriuk.com\/report-builder\/wp-json\/wp\/v2\/tags?post=1986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}