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