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

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,
"tiw" wrote in message
...
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

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

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

"Alan" wrote:

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

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" wrote:

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

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.
"tiw" wrote in message
...
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" wrote:

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