chart auto update

create 2 dynamic named ranges

Area=OFFSET(Sheet1!$D$2,MATCH(TODAY(),Sheet1!$D$3:$D$24,0),0,-7,1)
Area1=OFFSET(Sheet1!$D$2,MATCH(TODAY(),Sheet1!$D$3:$D$24,0),1,-7,1)

and populated the cahrts based on these named ranges. See attached.

Does this work for you??