We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Show the chart data based on hidden rows and columns

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.