Hi guys and gals,

I've got a bunch of data that I want to put in a chart - but it's a bit of a challenge.

Basically, row 1 contains week numbers, starting in column 5, then next week in column 8, next week in column 11 etc.
In column 5 below it is quantities of sales, in column 6 is the turnover, in column 7 is the margin percentage - then column 8 is qty, 9 turnover, 10 margin - etc.
In column 1 there's data we can ignore
In column 2 there's a category group number
In column 3 there's a product group number within that category group
In column 4 there's a brand

Now, what I'd like is this :
Per product group a chart / overview of the different brands and their TURNOVER in € (left Y axis) and MARGIN in percentage (right Y axis) per different week.

The raw data feed cannot be put in a different format.
The number of brands per product group differ and the number of product groups per category differ - every week there will be new raw data and in there, the number of weeks in total will differ.
I'd like to feed the raw data to a hidden sheet and have the charts alter based on loading new data.

It would be awesome if I could tick on/off the brands per chart, but that's a second question.

Example of raw data as picture attached - I'll try to upload a sample sheet asap.
Thanks for any help!

example data.jpg