Show empty cells as Gaps in Chart

[Unknown]

Is there a way to show empty cells in a series as gaps in a line chart? 

[Ramya Sivakumar]

Hi Jason, 

Greetings from Syncfusion. 

In XlsIO, the empty cell values in the chart series are displayed as gaps. You can also use the following code snippet to set the empty values as gaps in the chart series. 

Code Snippet: 

chart.DisplayBlanksAs = ExcelChartPlotEmpty.NotPlotted; 

Please check the sample and let us know if this is helpful. 

Sample link - https://www.syncfusion.com/downloads/support/directtrac/general/ze/F-173656203509078 

Regards, 

Ramya.