I have a PowerPoint presentation with several charts linked to an excel file. I have a need to change the sheet name that the charts are linked to. The data range will remain the same, just the sheet name needs to change. How can I accomplish this without manually updated each chart name series and data series? I have searched the internet for the past 4 hours looking for some insight into this problem. Any help would be greatly appreciated.
