Your can not use a named ranged that defines the whole of the chart data source at once.

Instead you need a named range for the labels and data of each series.


CHART_LABEL: =OFFSET(Sheet1!$H$2,,,Sheet1!$F$4,1)
CHART_DATA: =OFFSET(CHART_LABELS,0,1)

then use the select data dialog to enter the named ranges, which will then update the series formula to be
=SERIES(Sheet1!$I$1,'Chart Update With Name.xlsx'!CHART_LABELS,'Chart Update With Name.xlsx'!Chart_Data,1)