Have a dynamic named range formula that is picking up zeros in the data range instead of ignoring the zeros and only select values greater than zero. See Formula below. it will require some tweaking to fix the problem. Sample file attached.
=OFFSET(Chartdata_linked!$C$4,COUNTA(Chartdata_linked!$C$4:$C$613)-Chartdata_linked!$B$4,,Chartdata_linked!$B$4)
Thanks
Bookmarks