Dynamic range in chart reverts to static value

[excelIsland]

Hi,

I created a named range linked to a slider.

=OFFSET('Slides'!$B$2,0,0,6,'Slides'!$AB$1+1)

Problem is after I put in the range as the chart data range it reverts to -

='Slides'!$B$2:$H$7

Can anyone help with this? This is frustrating.

 

[excelIsland]

nvm ... I just took the extra time to put it in the individual series.