Pivot chart fo making charts dynamic

[rpinxt]

Ok I need help of Pivottable and Pivottable charts gurus.
Please see attached workbook.
On the first tab I have my data.

Now I want on this data to make my pivot (which is not the problem).
The driver (So filter) would be the yellow headed column (named CG).
Then on the pivot I want a pivot chart which looks like the chart on the second tab which I added as an example (its a picture).
This example was based on "fixed" data and for every change in column named CG we have a seperate graph.

So now I want to make this dynamic bij using a filter on CG.

However I cannot get the correct graph I need.
So column A (months) on X-axis and then double Y-axis for the amounts.
And the series should be column B (which is the split of column C), columns D to H which are amounts.

I am doubting if this can be done this way.....

[oeldere]

Did you make a table of the data to make it dynamic? Insert - table

[rpinxt]

Oeldere...no I did not use a table.
The data block gets generated by a macro every month.

Then I want use VBA to refresh the pivot which then also refreshes the graph.

Then from the graph or pivot i can use the filter on column named CG to switch to 1 of the 4 groups.
And below these groups there are several sub groups (column B) which then show as graphs.

[humdingaling]

why does it need to be in a pivot table?
if the chart you have currently made by a pivot chart?

have the chart run off a table and update the table with VBA