Stacked Bar Charts (Worksheets)

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit Bar Charts (Workbooks).

Stacked bar charts are an excellent way to show related data. They show how larger data divides into smaller categories.

Summary of Content

Create a Categorical Stacked Bar Chart
Create a Series Stacked Bar Graph
Show Data Labels

Create a Categorical Stacked Bar Chart

  1. Create a new chart
  2. Drag the column that will serve as your axis values to the Axis box. These values will serve as the fixed axis of your graph.
  3. Choose which column will serve as the values that determine the sizes of the bars in your bar graph. Place this column in the values box.
    You can also choose to have a simple Row Count in the values box. You can also apply aggregations directly in the values box.
  4. Place the column with the categories you would like to divide your data into in the Color box. This will split your bars into the number of categories represented in the column.
  5. Click on the color palette to update which colors are displayed on your graph.
Screen_Shot_2019-10-24_at_10.04.41_AM.png

Create a Series Stacked Bar Graph

  1. Create a new chart
  2. Drag the column that will serve as your axis values to the Axis box. These values will serve as the fixed axis of your graph.
  3. Choose which columns will serve as the values on your graph. Place all of the values that you would like to stack in the Value box.
  4. Click on the color palette to update which colors are displayed on your graph.

Show Data Labels

  1. [Prerequisite] A Vertical Bar Chart with columns on the Axis, Value and Color fields.Screen_Shot_2021-03-30_at_1.13.43_PM.png
  2. Open the Format tab in your visualization's plot and format panel.  
  3. Click DATA LABELS.
  4. Click the toggle switch(es) for Show Data Labels and/or Show Data Labels for Totals
    Selecting Show Data Labels will display labels for each individual bar segment. 
    Selecting Show Data Labels for Totals will display the entire bar total.
    Screen_Shot_2021-03-30_at_1.26.53_PM.png
  5. [optional] Customize your data labels using the available format options listed under the toggle (e.g. Orientation).

 

IMPORTANT: This document is specific to Sigma worksheets. To learn about this topic for Sigma’s new Workbooks feature, please visit Bar Charts (Workbooks).