Blanks graphed as zeros

[Lisa928]

I have a building YTD graph where the data is pulled from another source.

I am using a formula where it will pull the data, but if that month it is not available yet (or =0) then "", or a blank. The problem is the graph is graphing the blank as a 0. Because of this the line graphs looks like it plummets. Instead I want the line to just end.

Can I do this by formatting my data differently instead of VB?

 

[Aladin Akyurek]

Let the formula that pulls data return #N/A instead of "".

 

[Lisa928]

Thanks...I guess I was trying to complicate things!