Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dont show zero vaules in a chart | Charts and Charting in Excel | |||
I dont want #N/A! | Excel Discussion (Misc queries) | |||
Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
Dont know what to use. | Excel Worksheet Functions | |||
I know what I need but dont know how to do it | Excel Worksheet Functions |