Chart ignoring formulas but only plotting formula results

I am creating a line chart where the source data is the result of an =IF
formula. How do I get the chart to only plot the cells where there is a
result? Currently the chart is plotting a zero value for all the cells where
the formula does not yet show a result.

If( something, formula, NA() )
The otherwise blank cells now have #N/A in then (you can hide these with
Conditional formatting if they bother you)
Charts ignore these values
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JD" <[email protected]> wrote in message
news:[email protected]...
>I am creating a line chart where the source data is the result of an =IF
> formula. How do I get the chart to only plot the cells where there is a
> result? Currently the chart is plotting a zero value for all the cells
> where
> the formula does not yet show a result.