KNOWLEDGE BASE

Creating a Stacked Bar Chart That Adds up to 100%


Published: 17 May 2013
Last Modified Date: 18 Sep 2017

Question

How to create a stacked bar chart where the total for each bar adds up to 100 percent (%).

Environment

Tableau Desktop

Answer

  1. In the Stacked Bar Chart to 100% example workbook, right-click SUM(Sales) on the Columns shelf in the Primary Setup tab, and then click Add Table Calculation.
  2. In the Table Calculation dialog box:
    • In the Calculation Type drop-down menu select Percent of Total
    • Under Summarize the values from select Cell or Table (Across), and then click OK.
      Note: You can also select Table (Down) if the measure is on the Rows shelf.
    • To add a label to each bar, drag a measure (for example Sales) to the Text card.
For more information about creating a calculated field from the table calculations above, see Customizing Table Calculations in Tableau Help.

 

Additional Information

To view these steps in action, see the video below:
Did this article resolve the issue?