How to automate the date range when building Time-series charts in VBA

Hi,

I am having some issues in making the following functionality work using VBA - in fact I'm pretty much in the dark (this has previously been done manually):

I'm constructing a report wich should contain several charts, and these need to be formatted such that they appear proper direct from the vba-code.

The issue is that I'm having data-ranges that varies with what the report is supposed to contain (typically different dates). This is fetched from an access db.

For example this data should be plotted as a time-series:

Date Beta 1 year
mai. 12 0,90
apr. 12 0,89
mar. 12 0,92
feb. 12 0,91
jan. 12 0,92
des. 11 0,93
nov. 11 0,94
okt. 11 0,94
sep. 11 0,95
aug. 11 0,98
jul. 11 0,99
jun. 11 0,99
mai. 11 1,00
apr. 11 0,93
mar. 11
feb. 11
jan. 11
des. 10
nov. 10
okt. 10
sep. 10
aug. 10
jul. 10
jun. 10
mai. 10

But this will vary over different reports, i.e. I'm searching for a code that will automatically pick April 2011 - May 2012 as date range when running the macro.

All help is much appreciated