Help with displaying formulas in charts

[Ayo]

I am looking for a way to display zero values in my charts as gaps. Right
now I there is a big slant in my chart that I am trying to get rid of. The
range I am using has formular in them, so even when the cells evaluate to
blanks, they are displayed as zeros on the chart.
Any help will be greatly apprecaited.
Thanks

 

[מיכ×ל (מיקי) ×בידן]

Two possibilities I can think of"
1) Add an IF statement, to your formula, in order to present N/A instead of 0
[ use the function NA() ]
Something like that:
=IF(A1*B1=0,NA(),A1*B1)

 

[מיכ×ל (מיקי) ×בידן]

Third option will be using "Excel 2007":
http://office.microsoft.com/he-il/help/HA100485551033.aspx
Micky

Two possibilities I can think of"
1) Add an IF statement, to your formula, in order to present N/A instead of 0
[ use the function NA() ]
Something like that:
=IF(A1*B1=0,NA(),A1*B1)
--------------------------------------
2) Hide all the rows where the cell results as 0
[You can do it manually or if the 0 results changes lot of times - use a
macro to loop through them and hide accordingly]
----------------------
Micky

I am looking for a way to display zero values in my charts as gaps. Right
now I there is a big slant in my chart that I am trying to get rid of. The
range I am using has formular in them, so even when the cells evaluate to
blanks, they are displayed as zeros on the chart.
Any help will be greatly apprecaited.
Thanks

 

[David Biddulph]

Or http://office.microsoft.com/en-us/help/HA100485551033.aspx if you want it
in English.
--
David Biddulph

Third option will be using "Excel 2007":
http://office.microsoft.com/he-il/help/HA100485551033.aspx
Micky

Two possibilities I can think of"
1) Add an IF statement, to your formula, in order to present N/A instead
of 0
[ use the function NA() ]
Something like that:
=IF(A1*B1=0,NA(),A1*B1)
--------------------------------------
2) Hide all the rows where the cell results as 0
[You can do it manually or if the 0 results changes lot of times - use a
macro to loop through them and hide accordingly]
----------------------
Micky

I am looking for a way to display zero values in my charts as gaps.
Right
now I there is a big slant in my chart that I am trying to get rid of.
The
range I am using has formular in them, so even when the cells evaluate
to
blanks, they are displayed as zeros on the chart.
Any help will be greatly apprecaited.
Thanks

 

[Ayo]

Thanks.
The NA() function worked.

Two possibilities I can think of"
1) Add an IF statement, to your formula, in order to present N/A instead of 0
[ use the function NA() ]
Something like that:
=IF(A1*B1=0,NA(),A1*B1)
--------------------------------------
2) Hide all the rows where the cell results as 0
[You can do it manually or if the 0 results changes lot of times - use a
macro to loop through them and hide accordingly]
----------------------
Micky

I am looking for a way to display zero values in my charts as gaps. Right
now I there is a big slant in my chart that I am trying to get rid of. The
range I am using has formular in them, so even when the cells evaluate to
blanks, they are displayed as zeros on the chart.
Any help will be greatly apprecaited.
Thanks