The next version of EasyXLS will handle how the hidden and empty cells are displayed in a chart inside an Excel file. The data in chart series is affected by this new feature. An empty data point can reside in a gap, a zero value or the data points can be connected by lines.
The feature applies to XLSX, XLS an XLSB file formats.