Thread: Dont want to inlcude 0's in my chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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))





Reply With QuoteReply With Quote