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
Hi,
I think you may try:
e.g
Sample code:
…
//hidden empty cells
chart.PlotEmptyCellsType = PlotEmptyCellsType.Interpolated;
chart.PlotVisibleCells = false;
Thank you.