Dynamic chart clustering incorrect data

Hello everyone, long time reader, first time poster here.
I was hoping I could pick your minds about this chart problem I'm having.

I have some data, it represents the number of events that have been held in each of the four areas of the city of Liverpool (Live1, Live2, etc.) each week. I

I'm trying to create a clustered chart that a) shows the number of events held in each area of the city for the last four weeks, clustered together by area) and b) which dynamically updates when new data is added to the table each week.
I've succeeded in creating a chart which does this - dynamically updates, only shows the last four weeks of data - through the use of defined ranges, but the information is clustered on the chart by week, not by area.

So make this clearer, the chart that I have succeeded in making looks like this (the x-axis clustering the data by the week in which x amount of events took place in each area of Liverpool):
incorrectchartlayout.PNG

But I want the chart to look like this (where the x-axis clusters each week of data by the area in which it took place):
correctchartlayout.PNG

Normally, I would just flip the rows and columns:
switchcolumnrow.PNG

This seems to have the desired effect, but disables the dynamic element of the table which, of course, is kind of the whole point.
If you have any suggestions about how to do this I'd be the happiest person in the world - I've spent the whole day grappling with this and just cant get it to work!
I've attatched the document if it helps!
dynamicclusteredtest.xlsx

Thank you!