D
dharshanie
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
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