Stacked bars

While bar charts show comparisons among categories, CDP Data Visualization stacked bar charts show the bars divided into sub-parts. This demonstrates the cumulative effect of the component parts of a particular category.

To develop a stacked bar representation of European population, divided by its subregions, follow these steps.

  1. Remove Life Expectancy from the Y Axis shelf and un_region from the Colors shelf.
  2. From Dimensions in the Data menu, pull un_subregion onto the X Axis shelf.
  3. Under Measures, select population, and drop it onto the Y Axis shelf.
  4. Pull Country from the X Axis shelf onto the Colors shelf.
  5. On the Filters shelf, set year to 2010, and un_region to Europe.
  6. [Optional] Add all fields of interest to the Tooltips shelf. For example, add life_expectancy and gdp_per_capita.
  7. [Optional] Adjust Display Format for the values on the main shelves of the visual and in the Tooltip shelf.

    For example, set the gdp_per_capita to Currency, with $ symbol.

  8. Alias the fields on the shelves as UN Subregion, Population, GDP per Capita, and so on:
    1. On the shelf of the visual, click the caret-right icon to the right of the field.
    2. In the Field Properties menu, click the caret-right icon next to Alias.
    3. In the text box below Alias, enter the alias name of column, as it should appear in the visual.
    4. Click x icon at the top of the Field Properties menu to close it.
    5. Note that the shelf now shows the column with its alias name.
  9. Click Refresh Visual.
  10. Note how the visual changed. You can see the relative size of total populations for the subregions, and the component countries for all subregions.

    If you hover the mouse over the graph, you can see the tooltip text for each country.

  11. Rename the visual.
  12. At the top left corner of the Visual Designer, click Save.