How to Create a Stacked Column Chart with Statistical Significance

Introduction

This article will show you how to create a stacked column chart that compares two tables of data. This is typically used in tracker studies where one would show how the results have changed over time.

Here are fast food locations visited by gender from 2019 and 2020.

Here is the stacked bar chart that shows the change:

Note the significance testing as well as the change in % from the comparison table.

Requirements

Two tables that have the same row/column structure that shows Column Sample Size and Column Standard Error

Method

1. Select Visualization > Column > Stacked Column with Custom Tests

2. Under Inputs > DATA SOURCE > Table 1 select the table that you want to compare to

2. Under Inputs > DATA SOURCE > Table 2 select the table that will show the current state

3. OPTIONAL Number of categories below axis - Can specify # of categories below the axis

      Example: the above chart with 1 category below axis:

See Also

How to Create a Column Chart from a Variable

How to Create a Column Chart from a Table

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