Chart ignoring formulas but only plotting formula results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top