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