I have a graph that looks at a some standard values that correspond with a week number.
so I have 52 weeks each with a number set to it.

I would like a graph that takes in account the current week number and plots the corresponding value as well as the 5 previous values (rolling 6 weeks)

I could do this manually by selecting the graph's data and changing it to the next 6 weeks needed however this is time consuming.

so is it possible to do this via VBA or even without vba =S