Show the chart data based on hidden rows and columns

[weimeng]

Hi,


In Excel, by default , if we create a chart based on the hidden rows/cols, the chart will be blank, unless we enable the setting “Show data in hidden rows and columns” ( See Pic1&Pic2). So my question is whether Aspose has a property to support this setting.

Thanks,
Wei

[Amjad_Sahi]

Hi,

I think you may try:

e.g

Sample code:

…

//hidden empty cells

chart.PlotEmptyCellsType = PlotEmptyCellsType.Interpolated;

chart.PlotVisibleCells = false;

Thank you.