How to stop excel from plotting a "blank" cell with formula as zer

[Guest]

Hi,
I have an xy chart that plots Date vs. SVI. The SVI column has a
conditional formula that if the condition is met it will display a value,
otherwise it will display a blank cell.
Even though the cells appear blank they really contain a formula and excel
plots them in the chart as zero values. Is there a way to stop excel from
thinking that the value of the cell is zero? I don't want it to plot this
values. Please help.
Thank you

 

[Alan]

A chart will ignore #N/A, so in your formula try
=IF(your formula is true, your formula,#N/A)
Regards,

 

[Alan]

Sorry!
=IF(your formula is true, your formula,"#N/A")

 

[Guest]

Hi Alan,
I tried but it did not worked, it assumes that #N/A is text because it is
between "" and it still plots dat with an SVI value of zero. This is driving
me crazy. Any other suggestion? Thank you anyway.
Thalia

 

[Guest]

Hi Alan, I got it, just so you know you were on the right track but instead
of using "#N/A", you use NA() and excel considers is as null #N/A instead of
just plain text. My chart doesn't plot them as zeros anymore. Thank you for
guiding me in the right direction. Thalia

 

[Alan]

You're welcome, we all live and learn although I've used the #N/A trick to
avoid zeros on a lot of chart files. If NA() works for you then great!
Alan.