Hell All!

I have an excel report that is a combination of charts, graphs, slicers, and tables. I am now trying to create a simpler version in powerpoint for presentation. I copied and link-pasted several graphs into PP directly from the excel file. If I change the data in Excel then click the refresh button in PP the data updates. The problem is that I need to click that refresh button for each graph that I paste. I'm trying to write a rather simple code in vba that will target the charts/graphs specifically and refresh them. Something like...

Private Sub CommandButton1_Click()
ActivePresentation.Slides(2).select
Shapes("Chart 2").select
Selection.refresh
Obviously, this code isn't working. Anyone have any ideas?

Thanks