Excel charts in Powerpoint
Budget: $30 – $250 USD
I have a powerpoint with many charts embedded from a large Excel file. This is my template.
When I get a new project, I will create a copy of the PPT Template and a copy of Excel Template. I will load new data into the Excel and all the graphs will update. Now I need the graphs in the powerpoint to update. I have found a VBA code that changes the path to the new Excel file, but the charts do not update. Only way to update is to: Right click > Edit Data > Edit data. Then the correct Excel opens and that specific graph updates. But I expect to have 50+ graphs in the powerpoint and I do not want to update all one by one.
I will pay half of amount when a solution is demonstrated to work and other half when it has been working for 2 months.
When I get a new project, I will create a copy of the PPT Template and a copy of Excel Template. I will load new data into the Excel and all the graphs will update. Now I need the graphs in the powerpoint to update. I have found a VBA code that changes the path to the new Excel file, but the charts do not update. Only way to update is to: Right click > Edit Data > Edit data. Then the correct Excel opens and that specific graph updates. But I expect to have 50+ graphs in the powerpoint and I do not want to update all one by one.
I will pay half of amount when a solution is demonstrated to work and other half when it has been working for 2 months.