Powerpoint VBA chart with excel data

[vbaauto2016]

I have an odd problem and was wondering if anyone has a better approach altogether vs. helping me fix my current approach.

I have a robust excel and through a working macro:
1. I created 150 small charts and update their data
2. Creates multiple slides.

This all works fine, but everytime I edit the chart data in powerpoint using VBA it pauses and edits the hidden excel sheet in powerpoint.. no issue but it takes a lot of time to open and close excel for each powerpoint chart.

I thought of 2 other approaches, and here is where I could use some help.

1. Should I create all the data for the charts in excel first and then have each powerpoint chart just link to the one sheet using chartdata linking?

OR

2. Is there a way to have all the charts of a powerpoint use the same "hidden" excel sheet that automatically is generated when creating a chart.

Thank you any advice would be hugely appreciated.

 

[pbornemeier]

I would export the charts from Excel to PowerPoint as images and edit them in Excel as necessary. Use VBA to replace changed charts in PPT based on the dataset.