Yes, that is what we want. Now make the chart.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MattBeckwith"
wrote in message
...

The referenced web page says:

When an empty cell is filled with =NA(), Excel interpolates the missing
data, joining adjacent data points

I don't want the missing data points interpolated.

However, I went ahead and tried the NA() approach, as follows:

=IF('3'!B230,'3'!B23,NA())

But it just filled the cell with

#NA


--
MattBeckwith


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