DKY

Excel treats cells with formulas as Not Empty. The Not Plotted (Leave Gaps)
doesn't work because the cell is not empty.

When you have formulas, the fix is to use NA() instead of "". Excel will
place a #N/A in those cells. Excel recognizes NA() and interpolates through
the #N/A cells.

Your formula should look like: = IF(D10<"",1-(E10/D10),NA())

If you want gaps in your data series instead of interpolation, then you can
replace the formulas with values by copying data and using Edit - Paste
Special Values then remove all #N/As.

....Kelly




"DKY" wrote in message
...

Actually I have a formula in there that looks like this
=IF(D10<"",1-(E10/D10),"")
and when I go to Tools Options Chart Plot
Empty Cells as
is already set to (Not Plotted - Leave Gaps)
So, I would think that it would not plot it. I even tried deleting the
formula and it still plots as zero.


--
DKY
------------------------------------------------------------------------
DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=535942