Dont want to inlcude 0's in my chart

[mmb]

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>=Data!J$1,IF(Log!$R$2:$R$129<=Data!J$2,1,0),0),0))

 

[Jon Peltier]

Change the zeros in the formula to NA().

- Jon

 

[mmb]

Jon, Thank you, but it is not working.

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
_______

 

[Bob Phillips]

What does not working mean?

--
HTH

Bob

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

 

[Jon Peltier]

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

 

[mmb]

JOhn, Thank you.