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

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

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
 
A chart will ignore #N/A, so in your formula try
=IF(your formula is true, your formula,#N/A)
Regards,
 
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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top