Enable: "Show data in hidden rows and columns" in Chart data

[Robert Pouleijn]

In Excel u can check the property "Show data in hidden rows and columns" when defining the data range of a chart. Is it possible to set this property using the IChartShape object u get when adding a chart using Syncfusion.XlsIO?

[Shamini Kiruba Sobers]

Hi Robert, 

Greetings from Syncfusion support. 

You can enable the “Show data in hidden rows and columns” checkbox by setting the PlotVisibleOnly property to false as below. 

Code snippet: 

chart.PlotVisibleOnly = false; 

Kindly let us know if it helps. 

Regards, 

Shamini