Automatically put dynamic chart in specific PPT slide based on criteria of slicer (VBA)

[Djani]

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

 

[mrmmickle1]

You can just link the two together. When the chart is updated in the excel file the PowerPoint will update automatically.

https://support.office.com/en-us/ar...int-2010-692497a5-c7de-4486-a435-5af1eff02821

Just create the different cuts (Like you have done using slicers) once... then you'll never have to do it again.

 

[Djani]

Thanks for the tip, but that's exactly the issue. The dynamic chart have to be put in multiple slides. I can solve this by manually clicking on a criteria, copy-paste the chart, and do this dozens of times. However, if that's possible, I want this sequence to be automated since many people will make use of this report. If I link this chart via "Paste Link" to a PowerPoint then the chart will be changed whenever someone else changes the criteria of the slicer.

Since the layout/structure of the PowerPoint will always stay the same I was thinking of making the VBA script refer to the 2 criteria which you see in the picture above. E.g. the combination "Portugal" and "Note" will always be put in slide 8, the combination "Spain" and "Note" will be put in slide 9 etc. etc.

Do you have any suggestions regarding VBA?

 

[mrmmickle1]

There is alot of information online about how to move a Chart to a PPT.

Here are a few examples:

VBA Express : Multiple Apps - Export Excel range or Excel chart to PowerPoint (linked or unlinked)


Using Excel with Other Office Applications


PowerPoint VBA Code