Tushar Mehta has a routine that blanks out these N/A values, which

aren't plotted at the ends of a series, but are interpolated over

between valid points. I forget the precise name, but it has the words

Chart and N/A in it. Look at the list on the left side of his web site

(

http://tushar-mehta.com).

- Jon

-------

Jon Peltier, Microsoft Excel MVP

http://www.geocities.com/jonpeltier/Excel/index.html
_______

Whirlwind wrote:

> I'm having a similar problem, except that one of my series

> should not be graphed for observations that are the same

> as another series. I put an #N/A in those cells and they

> are not graphed. The problem is if some values show up,

> followed by some #N/As, and then some other values show up

> in a later observation, Excel interpolates between the

> observations that are not #N/A.

>

> Any ideas? Thanks,

>

> JR

>

>>Graphs will ignore #N/A values, so you could change each

>

> cell formula to

>

>>something like

>>

>>=IF(formula=0,#N/A,formula)

>>

>>Jerry

>>

>>Richard wrote:

>>

>>

>>>I am trying to create an x/y scatter plot from an excel

>>>sheet where the cells in the data range contain

>>

> formulae

>

>>>which sometimes return a zero value - when this occurs

>>

> I

>

>>>want the chart to ignore the value as though the cell

>>

> was

>

>>>empty but I am having no luck in doing this. It would

>>>also be nice if the LINEST function could be made to

>>>ignore zero values as well.

>>

>