Dont want to inlcude 0's in my chart
 

Here is my formula, When i creat my chart it shows all the blanks or 0 data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

Dont want to inlcude 0's in my chart
 

Change the zeros in the formula to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Here is my formula, When i creat my chart it shows all the blanks or 0
data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

Dont want to inlcude 0's in my chart
 

Jon, Thank you, but it is not working.

"Jon Peltier" wrote:

Change the zeros in the formula to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Here is my formula, When i creat my chart it shows all the blanks or 0
data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

Dont want to inlcude 0's in my chart
 

What does not working mean?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mmb" wrote in message
...
Jon, Thank you, but it is not working.

"Jon Peltier" wrote:

Change the zeros in the formula to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Here is my formula, When i creat my chart it shows all the blanks or 0
data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

Dont want to inlcude 0's in my chart
 

Yes, well, I answered too quickly. Since you have a complicated set of
nested sums, the NA() will only lead to woe.

Keep this range as is, then make another range that refers to this, but use
a formula like

=IF(A1=0,NA(),A1)

Then make your plot using this second range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Jon, Thank you, but it is not working.

"Jon Peltier" wrote:

Change the zeros in the formula to NA().

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"mmb" wrote in message
...
Here is my formula, When i creat my chart it shows all the blanks or 0
data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

Dont want to inlcude 0's in my chart
 

JOhn, Thank you.

"mmb" wrote:

Here is my formula, When i creat my chart it shows all the blanks or 0 data
on my chart . Is there a way to do it? Please help. Thank you.

=SUM(IF(Log!$A$2:$A$129=$A26,IF(Log!$R$2:$R$129=D ata!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))