Automatically select data between two dates

I have created several charts that uses stacked columns and a line graph from 5 data sets.(4 for the columns and 1 for the line)

my problem is that new data is added every week and i only want data graphed for the past quarter year (January-March / April-June / July-Sept / Oct-Nov). So basically once january, april, july, or october comes i want the chart to automatically move the data selection from the first week of the quarter to the final week entered.

i was thinking about using dynamic charts but i couldn't get them to work properly. not sure if they are advanced enough to do the task.

is there a simple way to make a macro or to program vba to do this? i have worked with some vba but not with charts. Any help would be appreciated.

thanks
-Adam