Anomalies

[megsT]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hi,
Trying to do a lab report for uni... I'm filling in a spreadsheet that I've downloaded which automatically draws a line graph from the data entered.
The line joins each point but I need it to skip an anomalous result... How do I do this?

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hi,
Trying to do a lab report for uni... I'm filling in a spreadsheet that I've
downloaded which automatically draws a line graph from the data entered.
The line joins each point but I need it to skip an anomalous result... How do
I do this?

Change the value of the anomalous point to #N/A.

 

[megsT]

Thank you! Will give it a go!