graph ignoring anomalies
 

Could anyone tell me how I can plot a line graph, but ignore points that are
anomalies (eg points that are 0)?
Thank!

graph ignoring anomalies
 

You could delete the anomalous values. Or if the values are returned by a
formula, change the formula to return NA() instead.

=IF(A10,A1,NA())

This leaves #N/A in the cell, but you can hide this with conditional
formatting.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"rjkmidget" wrote in message
...
Could anyone tell me how I can plot a line graph, but ignore points that
are
anomalies (eg points that are 0)?
Thank!