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.

Chart ignoring formulas but only plotting formula results
 

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" wrote in message
...
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.