Help with displaying formulas in charts

  • Thread starter Thread starter Ayo
  • Start date Start date
A

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


מיכ×ל (מיקי) ×בידן said:
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


Ayo said:
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
Click to expand...
Click to expand...
 
Or http://office.microsoft.com/en-us/help/HA100485551033.aspx if you want it
in English.
--
David Biddulph

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


????? (????) ????? said:
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


Ayo said:
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
Click to expand...
Click to expand...
Click to expand...
 
Thanks.
The NA() function worked.

מיכ×ל (מיקי) ×בידן said:
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


Ayo said:
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
Click to expand...
Click to expand...
 
Back
Top