replace zeros with nulls

[dharshanie]

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

Thanks in advanc

 

[Guest]

Pull-down:

Data > filter > Autofilter and select Non-blanks in both columns

 

[dharshanie]

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

 

[dharshanie]

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

 

[Guest]

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.