Help with displaying formulas in charts


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
 
Ad

Advertisements

×

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

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
 
D

David Biddulph

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
 
Ad

Advertisements

A

Ayo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top