Thread: Grouping chart range

Hello!

I have a column chart with information about products and shops. I'd like to add city information to the chart, grouping the shops. Does anybody know how to do it?

Current chart data:
Shop1 Shop2 Shop3 Shop4
Apple 3 4 1 2
Orange 2 3 3 4
Ananas 4 5 2 1

What I would like to obtain:
London London Manchester Manchester
Shop1 Shop2 Shop3 Shop4
Apple 3 4 1 2
Orange 2 3 3 4
Ananas 4 5 2 1

Check the files.

Thanks.