Dear all,

I have a report with one dynamic chart in a worksheet called "VIVA GRAPH". In the picture down below you will see on the left hand side two cells that are referring to the pivot table where the slicers are linked to. There are in total 2 (countries) x 9 (models) = 18 possible combinations.

\1

There is a PowerPoint that has to be updated on a monthly basis. The structure of the PowerPoint won't change, so e.g. the graph regarding "Portugal" & "Note" will be put in slide 8, the combination "Spain" & "Note" will be put in slide 9 etc.

I have found the first piece of code on the site of JonPeltier where you click on the chart and automatically put it in the PowerPoint. However, I want the VBA to take in account those 2 variables and put the chart into the respected slide. Again, the structure of the PowerPoint won't change!

Is it possible to create a VBA macro that automatically copy-pastes this one chart into a specific slide? When someone clicks on another criteria it will be put into another slide. This to prevent copy-pasting a lot.

Looking forward to hearing from you.

Yours sincerely,

Djani Sadloe