Thread: 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" <JD@discussions.microsoft.com> wrote in message
news:87ED70A4-957A-453E-A4C5-1223CE533F60@microsoft.com...
>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.