Thread
:
IF formulas creates zeros in a line graph
View Single Post
#
2
Nick Hodge
Posts: n/a
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?
Reply With Quote