How to enable connect datapoints with line option in Excel

Aspose.Cells Product Family
1

How to enable option connect data points with line?

The file uploaded is of scatter with line and marker chart. 1st chart has a null value in the data so we are getting discontinued line to avoid that we need to find the option by right-clicking the chart area, and clicking Select Data. In that dialog box, click Hidden and Empty Cells.

See the image below.
connectpoints.png (24.5 KB)

scatterWithLineAndMarker-NullValueSample1.zip (13.7 KB)

Need help to get a sample snippet code using Java aspose cells.

1 Like
2

@VaradS
Please set Chart.PlotEmptyCellsType as PlotEmptyCellsType.Interpolated:

	    Workbook   workbook = new Workbook(dir + "scatterWithLineAndMarker-NullValueSample1.xlsx");
	    Chart chart2 = workbook.getWorksheets().get(0).getCharts().get(1);
	    chart2.setPlotEmptyCellsType ( PlotEmptyCellsType.INTERPOLATED);
	    workbook.save(dir + "dest.xlsx");