Create 'blank' on Graph instead of 0 value?

[Cerestes]

Short Question:

What can I have the IF statement return as a result that will NOT graph at all. Just leave a hole in the graph.

Long Question:
I have a large range of values and dates.
1/1 1/2 1/3 ....etc
10 11 7 .......etc
8 12 6 .....etc

These values are pulled via VLOOKUP() from various places.
When VLOOKUP finds a blank cell, it returns a '0', which doesn't work for me.
I've added an IF(ISBLANK), to return "", which is (I believe) an empty cell.
The problem is, this is still graphing as a zero. So it will be graphing along nicely, and then shoot down to zero and back up again.

Thanks!

 

[Richard Schollar]

Todd

=IF(A1="",NA(),A1)

as an example

 

[Todd R K]

Richard

It worked perfectly.

Thank you and have a great New Year!

Todd

 

[Jon Peltier]

You're using a formula to get the value from elsewhere, right? (Otherwise the cell would really be blank, and Excel by default doesn't chart blank cells.) Instead of using

=Sheet1!A1

in the cell, use a formula like

=IF(LEN(Sheet1!A1)=0,NA,Sheet1!A1)

 

[Todd R K]

Jon

You are correct.

Thanks and have a great New Year!

Todd