Chart displaying "Trendline Error"

I have charts which plot linear data ranges with trendlines using named ranges and OFFSET to make the ranges dynamic.  Sometimes the chart series data range is a pair of cells containing zeros.  In t...