Error 438 - object doesn't support this property or method by chart.setsourcedata

Hello everyone!

I would need your help with the following issue:
I'm trying to create a macro, which loops through the selected worksheets, opens a powerpoint template for each, replaces some text and also changes the data source of the embedded charts with the pivot table range of that specific chart on the selected worksheet. My problem was initially, that there are several charts on each worksheet, but each sheet has the same set of charts (e.g. performance, top 10 searches). So I tried to set the embedded chart source by validating the pivot table name. But now I get run-time error 438 - object doesn't support this property or method by defining the cht.Chart.SetSourceData Source. But if I change the source to Sheets(solutionName).Range("a1") the code runs without error, but the chart doesn't get updated with the new source.

Please Login or Register  to view this content.

Thanks Norie!
That really solved the error. I forgot, that I already set pt with sheet variable.
My code runs without error now, but neither the texts are replaced with the function (though this worked fine before) nor the embedded charts in Powerpoint are getting updated, although the ppt template opens fine.

Now I separated the code for changing the embedded chart source and changed it a bit. The code runs without error, but it still doesn't changes the chart source.

Please Login or Register  to view this content.

Actually the original error got resolved, so I will post a new thread for the other issue.