Using Named Ranges in Excel Chart Series?

[pjy54914]

I spent a ton of time last year setting up macros to update/edit the series in 6 charts by using named ranges & vlookups on my data sheet. My data has been collected for 15 years, but the charts include data for only the last 10 years. I watched your Excel Dynamic Chart #10 video and I think I can figure out the whole offset whitch-a-jigee where it uses only the last 10 years data (last 10 rows). The thing is - I have to do this in 167 workbooks and need to figure out how to use macros to do it quickly.