Bar chart to represent product information over time

jmd25

Hi All

I am trying to create a bar chart per month/year to represent the count of a binary value on each sale of a product. For example, if you have apples, was it sold with or without VAT. My input data looks similar to the below:

Year	Month_Year	Branch_Number	Product	Month_Year	Sold with VAT	Sold with VAT Count
2023	2	1	Apples	2023-2	YES	2000
2023	2	1	Apples	2023-2	No	100
2023	2	1	Oranges	2023-2	YES	4000
2023	2	1	Oranges	2023-2	No	51
2023	2	2	Apples	2023-2	YES	1000
2023	2	2	Apples	2023-2	No	5
2023	2	2	Oranges	2023-2	YES	6000
2023	2	2	Oranges	2023-2	No	72
…	…	…	…	…	…	…

I am looking to present the information similar to the image below (apologies for the crude drawing). I may also need to represent the same information, but for all branch's in a similar dashboard, but not sure space will allow this.

Really appreciate any guidance on this. Have been playing around with setting all morning, and just cant seem to figure out how to get what I want. Sure it is probably something simple I am missing.

Thanks in advance,

Christina_H

There are a couple of chart settings that will get you what you want.

Create your layer as a bar chart with month/year on the x-axis and the count on the y-axis.

Then split by VAT

This gives you the double bars for with/without VAT.

Then you want batched charts, grouped by branch and product

Final output: