Check Andy Pope's site (http://andypope.info) for a technique to display a
gap for this situation.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"DesM" wrote in message
...

I have followed this thread and I have a particular problem that I
thought it was intended to solve.
I am plotting with dates on the X axis. The Y values are function
determined. Using the IF function I have tried giving the cell a NA
value but the plot then extrapolates between the points. I do not want
to give it a zero value.
But I actually want the gap.
I suppose I could, using a macro, copy the series and then delete any
cells with NA in them and then use this as the basis for the plot.
Is there a way of avoiding this?
Des M


--
DesM
------------------------------------------------------------------------
DesM's Profile:
http://www.excelforum.com/member.php...o&userid=24121
View this thread: http://www.excelforum.com/showthread...hreadid=511363