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

replace zeros with nulls
 

Pull-down:

Data filter Autofilter and select Non-blanks in both columns
--
Gary's Student


"dharshanie" wrote:


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

replace zeros with nulls
 

Thank You!!!
That's great-will have a go.


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

replace zeros with nulls
 

Thank You!!!
That's great-will have a go.


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

replace zeros with nulls
 

This 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 Student


"dharshanie" wrote:


Thank You!!!
That's great-will have a go.


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