Help with OFFSET Function

[BenCrockett]

I am re-building SEVERAL Reports and automating them - now that I have SQL access; I have a query that dumps the data I need. I have a weekly stats report, which tracks 56 weeks of performance data, for our Tech Support centers.

I have the Charts Dynamic somewhat – but what I would like to do, is have the OFFSET function dynamic as well, so it only looks at the current week and the past -56 weeks, I have tried COUNT, COUNTA, COUNT IF.. and I cannot get this figured out. I just want to the dump the data into the table, and be done with it. Haha.. I don’t have time to update the ranges.
I have looked through the Forum at similar topics on creating a dynamic ranges in the =OFFSET function.. And I don’t know what I am missing. And I am stuck, please help!
Not sure if this matters, but I use a FORM Control so the users can select which Metric on the chart they want to see - on the Dashboard Tabs..

My Offset functions you can see in the Name Manger - you can see what I am doing there, hopefully.

Anyway, I've attached my report – any help would be greatly appreciated.

----ADDING so.. I don't think in my case, I need to make my offset function dynamic - here's why.. My Offset Function is based off a preset range. If you look in the file, in Name Manger, the ranges the Offset function is looking at refers to LABELS =OFFSET(LABELS,Data!$b$73,0) I've moved the ranges in LABELS - and it works.. so if I can get the range in the LABELS to count or something...this would solve my issue (I hope I am making sense)