Home/ Questions/Q 8171
Next
In Process
Computing Staff
  • 2
Asked: 2021-11-26T13:28:54+00:00 In:

Powerpoint Chart Data Source – Set With VBA

  • 2

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.
chart.data = slide(1).Excel.Sheet(“Year2014”).Range(“A1:C12”)
Or
chart.data = slide(1).Excel.Sheet(“Year2013”).Range(“A21:C32”)

The sheet name and range are not fixed.

Share

    1 Answer

    1. 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: http://www.ask.com/answers/61085998…

      • 0