The data is set up in rows, with each column as a date.
In the chart the date is on the x axis and the data categorie values on the y axis.
I defined names as:
XDate = OFFSET(daily!$D$2,0,1,1,COUNTA(daily!$2:$2))
and
YBuildTarget = OFFSET(daily!$D$5,0,1,1,COUNTA(daily!$5:$5))
and for the series formula entered:
=SERIES(daily!$D$5, 'main daily.xls!'XDate,'main daily.xls!YBuildTarget, 1)
Thanks
Grace