Best way to plot key Acc buy what by period

[admin11]

Hi All 

I have below data , I like to know which data Visualisation is. Best ? 

I am thinking using stack bar chart by period .

The Stack bar is put COY . 

my issue what they buy I don't know where to place ?

COY	AMT	Brand	Year
AAA	100	Brand A	2018
BBB	200	Brand A	2019
CCC	300	Brand A	2020
DDD	400	Brand A	2021
AAA	10	Brand B	2018
BBB	20	Brand B	2019
CCC	30	Brand B	2020
DDD	40	Brand B	2021
AAA	1000	Brand C	2018
BBB	2000	Brand C	2019
CCC	3000	Brand C	2020
DDD	4000	Brand C	2021

[v-yingjl]

Hi @admin11 ,

Has this issue been solved? You can consider accpect the suitable reply as the solution so that ohter members would find it more quickly.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@admin11 , Year on-axis, COY on legend and Brand  on small multiple(if needed), AMT on value

https://www.youtube.com/watch?v=fYoQJFBldlY

[admin11]

@amitchandak 

After I watch you YouTube , I get a lot new idea. Thank you