Stacked Bars; Bar Visuals Example

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

Tip. This demonstration uses the visual previously created in Bar Visuals. Clone it, and make the changes to the duplicate visual.

To use this visual to see a stacked bar representation for Europe, divided by its subregions, follow these steps.

  1. Remove Life Expectancy from the Y Axis shelf and un_region from the Colors shelf.
    • On the shelf of the visual, click the icon to the right of the field.

    • In the Column Properties menu, click the icon next to Remove.

      removing the field
    • Click icon at the top of the Column Properties menu to close it.

  2. Under Measures, select population, and drop it onto the Y Axis shelf.
  3. Pull Country from the X Axis shelf onto the Colors shelf.
  4. From Dimensions in the Data menu, pull un_subregion onto the X Axis 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:
    • On the shelf of the visual, click the icon to the right of the field.

    • In the Field Properties menu, click the icon next to Alias.

    • In the text box below Alias, enter the alias name of column, as it should appear in the visual.

    • Click icon at the top of the Field Properties menu to close it.

    • 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.