Is it possible to create a macro that will extend the graph source by 1 each time the button is pushed?
I have week 1-52 going down the left, then machine names along the top with figures automatically inputted with a cell offset at the end of the week during a macro routine.
I would like if possible each week this macro is ran, the data range for the graph is dropped down by 1.

So currently I have weeks 1-11 on the graph, end of next week, it will extend it down to the 12th row.

The data range is about 20 across, and the graph will only show data from columns 1,4,9 (example)
The charts will be on a separate sheet not an actual chart sheet.

Ta