Decouple chart from source data

[vvlad]

Hello,

I have an application that creates an Excel workbook, inserts some data into a sheet and draws a chart based on the data. In the end I would like to make the lines that contain the data disappear.

I can not remove nor delete these lines, in this case the chart also disappears. I could write them white on white, but I do not like this idea.

Is there a better way to accomplish this? Can I somehow fix the chart, make it independent from the original source?

Thanks.


vlad