Line charts | Join points despite gap in data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 13 Feb 2007 11:54 GMT

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

Reply to this Message

Bernard Liengme - 13 Feb 2007 12:58 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
> Is there a way to join two points on a line chart/scatter graph
[quoted text clipped - 3 lines]
> Thanks in advance,
> Paul

Reply to this Message