100% stacked bar (column) chart

100% stacked bar chart

100% stacked column chart

A 100% stacked bar (column) chart compares two or more measures across one or two dimensions. The sum of all the measures represents 100% of a dimension. This chart type displays bars or columns composed of segments. The segments represent the measures as percentages. Each measure is represented by a different color. The measures that you select need to show composition; therefore, they should be comparable and share the same scale and units of measurement.

In the bar charts, the measures are placed one after the other, from left to right. The width of each segment represents the measure's percentage related to the whole.

In the column charts, the measures are placed on top of each other. The height of each segment represents the measure's percentage related to the whole.

This chart type is best used to highlight the contribution percentage of each measure to a dimension, when the cumulative total is not important.

When to use

The 100% stacked bar (column) chart can be used to illustrate the contribution percentage of each of the following measures to 100% of a dimension:

  • Sales and marketing costs, travel expenses, and entertainment costs – to the operating cost for each department.
  • Building rent, insurance costs, subscriptions, and utilities – to the administrative expenses for each city.
  • Operating and non-operating costs – to the total costs for each line of business and country.

The 100% stacked charts are useful when the sum of the values is not important. Instead, the value resides in showing the trend for each measure across the dimension values, or for the measures within a specific dimension value.

A good rule is to use a maximum of three or four measures; otherwise, the chart can become hard to read.

Data requirements

To build this chart, define the data fields as follows:

  • Dimension – One or two dimensions
  • Measure – Two or more measures
  • Tooltip – (Optional) One or more measures
  • Trellis – (Optional) One dimension

Use case

View the following use cases for the 100% stacked chart, based on the chart orientation.


For details on how to customize your visualization, see Visualization settings.

For a whole list of visualizations, see the following topics:

Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.