A 100% stacked bar chart is used to show the relative percentage in stacked bars, where the total of each stacked bar always amounts to a 100%. It differs from normal stacked bars because the lengths of 100% stacked bars never vary because they all add up to a 100%.
Let’s now see how to build a 100% stacked bar chart on Tableau step-by-step. Our goal is to create a chart showing the percentage of sales per each sub-category in each region from the Sample Superstore data source.
Step 1. Create a stacked bar chart
- Connect to the data source Sample – Superstore.
- Drag Sub Category (under Product) to Columns.
- Drag Sales to Rows. You will get a standard bar chart. Now drag Region (under Location) and drop it on Color in the Marks card. You will get a stacked bar chart.
Step 2. Now modify it into a 100% stacked bar chart
- Right click on Sales in Rows, select Quick Table Calculation and then Percent of Total. Nothing will appeared to have changed.
- Right click on Sales in Rows again, and select Edit Table Calculation. When the table calculation window opens up, under Compute Using click on Specifi Dimensions and then untick Sub Category so that only Region is ticked as an option.
- Fit graph to Entire view from the toolbar.
Don’t wait! Contact us to learn more and continue to follow upcoming news on our website and LinkedIn channel.
