Chart to Ignore NA or 0

Hi guys, I have had 0 success in trying to get my chart to ignore zeros or NA. On the graph data worksheet I have my 12 month rolling formulas. Maybe I have to make changes there in order to ignore the zeros and NA? I need them to ignore it because it is referring back to an input page. Basically so whoever is using it does not need to go to another tab.

Excel charts automatically ignore the #NA error. So make your formulae return this error instead of 0, and you should be fine.