Charts - Source Data based on Named Ranges

i am trying to create charts that will update automatically based on (1) the selection of a state, and (2) entering new data into a table.

here is the named range i have created for the Category (X) axis labels, which works when i enter into the source data:
=OFFSET(Data!$D$1,,,2,COUNTA(Data!$D$1:$IV$1))

here is a named range i have created for one of the series in my table, which the chart will not accept as source data. the range can is properly selected when using the "go to" (F5) command, but it doesn't seem to want to work in the chart.
=OFFSET(Row_Start,,,1,COUNTA(Row_Start:Row_End))

Row_Start and Row_End are named ranges that point to a cell in the table based on the state selection.

I discovered the problem but not yet the solution. My data is on one tab, and my chart is on its own worksheet.

The named range "DataLabels" can be looked up using F5 from either sheet, but the other named ranges do not work from the chart sheet, only the data sheet.

I need to figure out what is causing the discrepancy.