Chart Error on Negative or Zero Values

[energistics]

Hey guys
I have a little problem and cant figure it out.


Created these two Named Ranges




CFMPS named range refers to =OFFSET(CFM!$X$26,0,0,COUNT(CFM!$X:$X))
CFMSCFM named range refers =OFFSET(CFM!$AA$26,0,0,COUNT(CFM!$AA:$AA))


then I have a chart that refers to these two named ranges...
thing is that when I scrol down to the chart I get an error messege popup
Negative or zero values cannot be plotted.


How can I modify this formula to ignor these values?


Thanks in advance
Energistics

 

[oldbrewer]

43.........0.........24........-7 etc

use a helper column to check each value and if it is less than 1 put =na() in the helper otherwise the positive number ?

 

[oldbrewer]

offset(A1,2,3) I understand but not offset(A1,0,0,35)

 

[energistics]

Can it be done without the helper column?


i.e can I have the chart have a named range that ignores negative values and blanks and posibly cells containing
formulas?

 

[oldbrewer]

helper columns can be placed out of site, even on a new sheet....