Summary: Stacked Bar Charts are similar to Stacked Column Charts and can be used to visualize data with one or two dimensions and one metric.
Stacked Bar charts are a variation of Bar charts. Your data needs to have at least 2 dimensions and one metric to be represented in a Stacked Bar chart. The first dimension will be on the Y axis and the second dimension would be represented by multiple stacked areas with different colors, repeated for each value of the first dimension.
Stacked Bar charts can also have one dimension and multiple metrics. In this case the dimension will be on the Y axis and the metrics would be represented by multiple stacked areas with different colors, repeated for each value of the first dimension.
Chart Options
| Option | Explanation |
|---|---|
| Y Axis | The Dimension used to populate the Y axis values. |
| Series | This will show the values of the segments of the second dimension (each will be drawn in a different color). |
| Switch X-Axis/ Series | Provides an alternative view of the chart by switching between the dimension used to populate the Y axis and the one used to populate the stacked segments draw with different colors. |
| X Axis As % | Draws all values as percentages of total, rather than absolute values. This allows comparing percentages of segments across each bar in the Y axis. |
| Show Data Labels | Will show numeric data labels for each data point in your chart. |
| Numbers Format | Change the format of the numbers used in the Axes, data labels and on-hover data call-outs of the chart. |
| Legend Location | Select the location for the legend that shows the color coding of the colored stacked segments. |
| Sort Y-Axis | Select the value by which you would like to sort the Y axis. This can be the Y axis dimension or the value of any of the segments from the second dimension. |
| Sort Order | Choose ascending or descending order. This is only available if you select a value to sort by in the previous option. |
| Limit Number of Y axis Values | This limits the number bars. By default, there is no limit |
| Show Other category for Series | This aggregates all values that fall beyond the limited number of bars into one category called “Other”. This is useful for charts where the higher values are consolidated within the first few segments, as it will aggregate all other segments into other and show as a separate point in the graph. This option is only available if there is a limit set to the number of bars |
| Limit Number of Series | This limits the number stacked segments. By default, the stacked Bar chart is limited to 50 segments |
| Show Other category for Series | This aggregates all values that fall beyond the limited number of series (or stacked segments) into one category called “Other”. This is useful for charts where the higher values are consolidated within the first few segments, as it will aggregate all other segments into other and show as a separate point in the graph. This option is only available if there is a limit set to the number of series. |
| Rows Per Page | Allows to separate the chart into pages. You can go to the next or previous page by the links on the top right corner of the chart. |