How to remove blank space?

D

Daniel

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
 
D

David Biddulph

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
MS Word normal.dot cannot be fixed 'text box' appears each time 4
One extra x axis item that wont go away - can anyone help? 3
Remove Identical words 0
Issue with blanks and spaces 56
Charting blanks as spaces 1
Formating bolded text exclusively. 0
Removing Line Numbers 4

Top