CODEWITHSUNDEEP
vbaexcelpowerpoint
Jackery Xu
Jackery Xu

Reputation: 402

edit chart data in powerpoint

I would like to edit the values of a chart within a powerpoint file. I can't seem to find the appropriate methods like .Range and .Cell anywhere.

 ActivePresentation.Slides(sl).Shapes(sh).Chart.DataTable

does not seem to have all the methods in the conventional DataTable method.

Upvotes: 5

Views: 19248

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

Something like this should work:

With ActivePresentation.Slides(sl).Shapes(sh).Chart.ChartData
    .Activate
    .Workbook.Sheets(1).Range("A1").Value = "test_data"
    .Workbook.Close
End With

Upvotes: 13

Related Questions