SOLVED Dynamic Range Tables

I have:

Week Value
1/1/12 17
1/8/12 12
etc etc

The values get filled in as time passes and go from 0 to positive integer. I want to graph up to the current date.
I made dynamic variables:
Value
=OFFSET($B$2,0,0,weekday(today()),1)
Week
=OFFSET($A$2,0,0,weekday(today()),1)

I then attempted to plug this into a scatter plot:
Y series ='Sheet1'!Value
X series ='Sheet1'!Week

Excel is saying this /\ is wrong.

This is seriously stumping me!

Any help would be appreciated.

Thank you,

Vitaly