Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |