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

Hi,

The attached file plots a chart between two dates specified in cells E1 and E2. I think this should get you started.

Sure.

If you take a look in the names editor (CTRL & F3) you will see two named ranges.

Dates refers to

=INDEX(Sheet1!$A$1:$A$20000,MATCH(Sheet1!$E$1,Sheet1!$A$1:$A$20000,0)):INDEX(Sheet1!$A$2:$A$20000,MATCH(Sheet1!$E$2,Sheet1!$A$1:$A$20000,0))

a range between the "start" date in E2 is found in column A and the "finish" date found in column B


Data uses offset to define the data alongside the dates named range.