View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JD
 
Posts: n/a
Default 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.