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.