Excel VBA: Editing Waterfall Workbook in PowerPoint

Question

I want to edit a (blueprint) chart I made PowerPoit via excel.

oPFile.Slides("charts").Select
With oPFile.Slides("charts")
    Dim t
    Set t = .Shapes("Diagramm 12").Chart
        t.ChartData.Workbook.Activate
        t.ChartData.Workbook.Worksheets(1).Cells(4, 2).Value = wksSource.Cells(67, 2).Value
end with

This works fine, but as soon I switch the chart to a waterfall Chart it doesn't work I get the error:

The Method 'Workbook' for the object 'chartData' failed (translated from germanso might be slightly differnt) 
errnumber: -2147467259 

When I switch back to antoher chart type it works fine ( aggain)

How do I edit waterfall charts, did they forget ti put the method workbook into it?

question from:https://stackoverflow.com/questions/65921324/excel-vba-editing-waterfall-workbook-in-powerpoint

Answer 1

Waitting for answers