Give a chestnut! Tableau Tips (36): Quickly make nested bar charts

Nested bar charts are generally used in scenarios where resource coverage and indicator progress are compared, which can make related data look more contrasting.

Resource coverage: such as the total amount of resources and the amount allocated to each area, used to view the superiority of each area in the distribution of resources;

Indicator completion progress: for example, each person's planned workload and actual completed workload per month, used to compare the progress.

So how do you make a nested bar chart in Tableau? 

In this issue of "Give a Chestnut", the Tableau technique that Ada wants to share with everyone is: Quickly make nested bar charts. 

Here, we use a global order data source to create a two-year comparison by making a nested bar chart. Other application scenarios can be produced by referring to this step. 

Specific steps are as follows:

Step 1：create two calculated fields

Sales in 2010: IF YEAR ([Order Date]) = 2010 THEN [Sales] END

2011 sales: IF YEAR ([order date]) = 2011 THEN [sales] END

Step 2：drag the "measure name" to the filter

Step 3：generate overlapping bar chart

Drag the Product Subclass to the column, drag the Measure to the row, and drag the Measure Name onto the color card. Generate an overlapping bar chart.

Step 4：Drag the "Measure Name" to the size of the tag card.

Drag the Metric Name to the size of the tag card. Distinguish between 2010 and 2011 years.

 Step 5：close the stack mark

Turn off the "stacking tag" on the "Analysis". This "nested bar chart" is formed.

In fact, nested bar charts are more than this. Do you know the other methods of production? Click "Write a message" below to let me know!