# Bar in Bar Chart and Reference Line (Part 1)

> 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…
> URL: https://mip.com.au/blogs/bar-in-bar-chart-and-reference-line-part-1/
> Last modified: 2026-08-06T04:22:19+00:00

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!
