Macro to move chart range each time one row down

[Kinna]

Hi,


I need a macro to update chart ranges every month, the concept is simple, I need to show in my chart always the last 3 months, but I can't figure how to do that kind of macro to move the range down on my table.

I tryied to record something with the macro recorder, but all it does is move the range down from rows 2, 3 and 4 to rows 3, 4 and 5.
Next month I'll need to move from 3, 4 and 5 to 4, 5 and 6.