Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tiw
 
Posts: n/a
Default 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
  #2   Report Post  
Alan
 
Posts: n/a
Default

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



  #3   Report Post  
Alan
 
Posts: n/a
Default

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





  #4   Report Post  
tiw
 
Posts: n/a
Default

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






  #5   Report Post  
tiw
 
Posts: n/a
Default

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








  #6   Report Post  
Alan
 
Posts: n/a
Default

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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 08:10 PM
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. QUEST41067 Excel Discussion (Misc queries) 1 January 15th 05 10:29 PM
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? Markus Obermayer Excel Worksheet Functions 1 January 4th 05 09:01 PM
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 Ian Ripsher Excel Discussion (Misc queries) 0 November 26th 04 09:43 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"