Cannot get ChartData Workbook for waterfall chart in PowerPoint. RRS feed

  • Question

  • Hi,

    In my VSTO application we use Chart.ChartData.Workbook property to fetch the workbook that contains the chart's data, so that we can update the data. It works fine for most of the charts, but when user has a Waterfall chart (office 2016) this property fails to fetch the workbook. It throws "Error HRESULT E_FAIL has been returned from a call to a COM component." exception when we try to access the waterfall charts data workbook.

    In one of "stack-overflow" post (i am unable to add link here) it is mentioned that it is due to an issue with the interop assemblies (that the interop assemblies don't support certain new type of charts introduced in office 2016)

    So is there any way we could access the waterfall charts data to manipulate it? 

    Thursday, October 17, 2019 3:18 PM