# 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

×

#### ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ

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

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.