Bar in Bar chart is very useful for comparing values, which is intuitive. Reference Line is commonly used to show a standard that can show if the value above the standard or not. The following chart shows the sales of different sub-categories in 2018 and 2019 using a bar in bar chart with two reference lines showing average sales. Let’s do it together!

Step 1: Create sales for 2018 and 2019.


Step 2: Double Click “2018 Sales” and “2019 Sales”, select Bar chart. Then drag “Measure Values” to columns and put “Measure Names” to size. Filter on the year you want.

Step 3: Click Analysis and Turn off the Stack Marks.

Step 4: Drag Date to colours to colour the bar chart.

Congrats! We finish the Bar in Bar Chart!

Camille Shi
Author: Camille Shi