Line charts | Join points despite gap in data

[Paul]

Hi,
Is there a way to join two points on a line chart/scatter graph
despite a gap in the data? I have several samples that were each
tested at different time points and I would like to join the data from
each time point together despite the existence of 'empty' time points.
Thanks in advance,
Paul

 

[Bernard Liengme]

Two ways:
a) replace the gaps by =NA() which displays as #N/A; the chart engine
ignores these
OR
b) click chart to activate; use Tools | Options and open chart tab; specify
how to "Plot Empty Cells" - you need interpolate
best wishes