replace zeros with nulls

  • Thread starter Thread starter dharshanie
  • Start date Start date
D

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
 
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.
 
Back
Top