Line charts | Join points despite gap in data

P

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
 
B

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
 
Top