Stacked Column Chart- Percentage

[Anonymous]

Hi,

How we can create a desired stacked column chart. Sample chart & data is attached for your reference.

Total % will be 100% for each location. 

Sample Chart:--

Sample Data:--

Year	Week	Month	Location	Category
2019	Week 6	Feb	B	SBS
2019	Week 6	Feb	B	MCM
2019	Week 6	Feb	B	ABC
2019	Week 7	Feb	A	SBS
2019	Week 7	Feb	A	ABC
2019	Week 7	Feb	B	MCM
2019	Week 7	Feb	C	ABC
2019	Week 7	Feb	C	XYZ
2019	Week 8	Feb	A	XYZ
2019	Week 8	Feb	A	MCM
2019	Week 8	Feb	B	ABC
2019	Week 8	Feb	C	MCM
2019	Week 8	Feb	C	MCM
2019	Week 9	Feb	C	SBS
2019	Week 9	Feb	B	ABC
2019	Week 9	Feb	B	SBS
2019	Week 9	Feb	B	SBS
2019	Week 9	Feb	B	ABC
2019	Week 9	Feb	A	XYZ
2019	Week 9	Feb	C	ABC
2019	Week 9	Feb	C	SBS