Dear all,

I have a report with one dynamic chart (=one object for VBA) in a sheet 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.



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.

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