How to make a progressive chart being linked to fixed columns with changing values on weekly basis

[yousafnoor]

Tuesday Col A Col B Col C Col D ...... so on Value for a progressive chart. The chart to be continued for years with new weekly values.
Wednesday Value Value Value Value ......so on The left side values will be linked on a different workbook or sheet or the same sheet with a new tab.
Thursday Value Value Value Value ......so on
Friaday Value Value Value Value ......so on
Saturday Value Value Value Value ......so on
Sunday Value Value Value Value ......so on
Monday Value Value Value Value ......so on

**Coloums are fixed but values changing every week

 

[yousafnoor]

Sorry!
I think I was clear enough about my question:
I tried to post the screen shot but it did not work