IF formulas creates zeros in a line graph
 

When Using an =IF(,,) function like =IF(A1="","",A1-A2) if A1 is blank Excel
still shows a zero in the graphs even when show blanks as zero option is not
selected. Any way to fix this?

You could replace your "" with N/A() this is not plotted

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Regulator" wrote in message
...
When Using an =IF(,,) function like =IF(A1="","",A1-A2) if A1 is blank
Excel
still shows a zero in the graphs even when show blanks as zero option is
not
selected. Any way to fix this?