Anomalies

M

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?
 
B

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?
Click to expand...
Change the value of the anomalous point to #N/A.
 
Top