replace zeros with nulls
 

Can someone tell me how I could not plot null cells in the middle of a
large range of data?
To make myself a bit clearer- for example let's say I have data from A1
to A10000 in which some cells are blank cells and I would like to plot
A1-A10,000 against B1- B10,000 BUT excel seems to plot the blank cells
in either columns as zeros in the graph! Is there anyway I could get
excel to just let the null cells be null cells isntead of making them
zeros?

Thanks in advance


--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: http://www.excelforum.com/member.php...o&userid=23673
View this thread: http://www.excelforum.com/showthread...hreadid=528512