Is there a way of partially clearing the chartdataworkbook?
As per my requirement the existing chart would have some predefined data let say around 11 rows, now when i clone the slide i might just want 5 rows.
So i am setting the categories and series as per the requirement, it works fine but when i do “Edit Data” on chart the excel sheet still contains 11 rows.
i can use
chart.ChartData.ChartDataWorkbook.Clear(), but i lose the formatting and will have to first store the formatting and then reapply it.
Hence i just want to clear a part of the ChartDataWorkbook, let say only the 6 rows, is there a way of achieving this?
I hope i am able to clarify myself.