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!