empty values in a line-graph when using a formula

[Guest]

I use a bar graph to display actual data and a line graph to display Budget data. Now, for obvious reasons, I only want to show data until February. The problem is that the line graph shows 0 (zero) values (which are the result of a formula like IF[ (A1="FEB-02";B1;"") ]and the bar graph does not show 0 (zero) values.
I get the following situation in a graph:
Jan Feb Mar Apr May
Actual 5 6 8
Budget 6 5 5 0 0

 

[Aladin Akyurek]

Use

=IF[ (A1="FEB-02";B1;NA())

instead of

IF[ (A1="FEB-02";B1;""

Aladin

 

[Guest]

Aladin, thanks for an efficient and FAST answer. It did the trick.
Thanks a lot and eh... DE GROETEN VANUIT.... DRUNEN, NOORD-BRABANT, THE NETHERLANDS.

 

[Guest]

Aladin, thanks for an efficient and FAST answer. It did the trick.
Thanks a lot and eh... DE GROETEN VANUIT.... DRUNEN, NOORD-BRABANT, THE NETHERLANDS.
ps. what kind of lecturer are you ?