empty values in a line-graph when using a formula

Feb 19th, 2002, 05:51 AM

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 · Feb 19th, 2002, 06:02 AM

Use

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

instead of

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

Aladin

Feb 19th, 2002, 06:28 AM

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.

Feb 19th, 2002, 06:28 AM

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 ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 05:51 AM	#1
Guest Posts: n/a	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

Feb 19th, 2002, 06:02 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	Use =IF[ (A1="FEB-02";B1;NA()) instead of IF[ (A1="FEB-02";B1;"" Aladin

Feb 19th, 2002, 06:28 AM	#3
Guest Posts: n/a	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.