How to remove blank space?
 

I have created a line chart from the data source that contains either blank
space or is null. I tried to remove blank space or cell has value is null
from this line chart but could not. Please help!

Thanks,

Daniel

How to remove blank space?
 

Replace the empty cells by #N/A.
Either =IF(A1="",NA(),A1), or modify an existing formula appropriately.
--
David Biddulph

"Daniel" wrote in message
...
I have created a line chart from the data source that contains either blank
space or is null. I tried to remove blank space or cell has value is null
from this line chart but could not. Please help!

Thanks,

Daniel