Solved Powerpoint chart data source - set with VBA

April 24, 2015 at 05:26:11
Specs: Windows 8, 8 GB
Say I have a powerpoint presentation with two slides.
Slide 1 has an excel object embedded in it - not linked.
Slide 2 has a chart.
What VBA code would I need to modify the data source of the chart to point to a range on the excel object on slide 1.

eg. = slide(1).Excel.Sheet("Year2014").Range("A1:C12")
Or = slide(1).Excel.Sheet("Year2013").Range("A21:C32")

The sheet name and range are not fixed.

See More: Powerpoint chart data source - set with VBA

Report •

April 26, 2015 at 01:10:44
✔ Best Answer
To resolve the above error message, follow the below mentioned steps:

1. Click File, then choose Save As.
2. Save the PowerPoint file at a new destination with the same or a new name.

For more:

Report •
Related Solutions

Ask Question