This article describes how to create a stacked column chart from an existing table like this:
To a chart like this (a 100% stacked column chart):
The same process can be used to create a column chart where the total does not add up to 100%. For example, the below chart was created using the same data as above, but replacing the percentages with the count for each cell:
Requirements
At least one of the following:
- A table with at least two columns and at least one row.
- Two variables.
Method 1 - via the visualization menu
- Select Visualization > Column > Stacked Column.
- Click on the page to place the visualization.
- Under Data > DATA SOURCE > Output in 'Pages' select the table that you want to base the chart on. Alternatively, select a variable from Variables in 'Data' for data you want to base the columns on.
- OPTIONAL: If using Variables in 'Data' in Step 4, select your second variable in Data > DATA SOURCE > Group, for the variable that you'd like to stack the column on.
- OPTIONAL: If using variables as input, go to Data > DATA MANIPULATION and tick Convert to percentages/proportions if you want to show %s rather than count.
- OPTIONAL: Under Chart make other adjustments to change the appearance of the visualization.
- Click Calculate and/or ensure that Automatic is checked.
Method 2 - using an existing table
- Select the table.
- Go to the object inspector, then select Visualization > Column > Stacked Column.
- OPTIONAL: Under Chart make other adjustments to change the appearance of the visualization.
- Click Calculate and/or ensure that Automatic is checked.
Note
Important information about editing captions:
Visualization caption edits may not be retained when a visualization with a nested table is switched back to table. Normally, this only occurs when you double-click the caption and edit the text directly. As a workaround, we recommend using Appearance > CAPTION > Edit caption to edit your captions.
Next
How to Create a Clustered Column Chart
How to Create a Stacked Column Chart
How to Create Several Column Charts Using Small Multiples
How to Add a Line to a Column Chart (Second Y-Axis)
How to Customize the Color of a Single Category in a Bar, Column, or Pyramid Visualization
How to Apply a Gradient Palette to a Bar, Column, or Pyramid Visualization