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.
Two tables that have the same row/column structure that shows Column Sample Size and Column Standard Error
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: