software

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: www.excelforum.com/member.php...oamp;userid=23673
View this thread: www.excelforum.com/showthread...hreadid=528512Pull-down:

Data gt; filter gt; Autofilter and select Non-blanks in both columns
--
Gary's Studentquot;dharshaniequot; wrote:

gt;
gt; Can someone tell me how I could not plot null cells in the middle of a
gt; large range of data?
gt; To make myself a bit clearer- for example let's say I have data from A1
gt; to A10000 in which some cells are blank cells and I would like to plot
gt; A1-A10,000 against B1- B10,000 BUT excel seems to plot the blank cells
gt; in either columns as zeros in the graph! Is there anyway I could get
gt; excel to just let the null cells be null cells isntead of making them
gt; zeros?
gt;
gt; Thanks in advance
gt;
gt;
gt; --
gt; dharshanie
gt; ------------------------------------------------------------------------
gt; dharshanie's Profile: www.excelforum.com/member.php...oamp;userid=23673
gt; View this thread: www.excelforum.com/showthread...hreadid=528512
gt;
gt;


Thank You!!!
That's great-will have a go.--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: www.excelforum.com/member.php...oamp;userid=23673
View this thread: www.excelforum.com/showthread...hreadid=528512
Thank You!!!
That's great-will have a go.--
dharshanie
------------------------------------------------------------------------
dharshanie's Profile: www.excelforum.com/member.php...oamp;userid=23673
View this thread: www.excelforum.com/showthread...hreadid=528512This is a nice one to keep in your mental toolbox. If you want to display
the fact that data is missing, then leave the blanks in. If you want better
looking plots, then filter them out.
--
Gary's Studentquot;dharshaniequot; wrote:

gt;
gt; Thank You!!!
gt; That's great-will have a go.
gt;
gt;
gt; --
gt; dharshanie
gt; ------------------------------------------------------------------------
gt; dharshanie's Profile: www.excelforum.com/member.php...oamp;userid=23673
gt; View this thread: www.excelforum.com/showthread...hreadid=528512
gt;
gt;