chart auto update

**navwelch** · 08-01-2012, 04:59 AM

Hi i m having an issue with charting. I hav excel files that has data n charts. i need to update the data everyday n also the charts. however the charts have to represent the latest 7 days. is there a way by which the chart reflects the latest 7 days data. it wd greatly save my time!

i am attaching a sample excel for reference..

Thx

**Ace_XL** · 08-01-2012, 05:25 AM

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??