Hi

You could use Advanced Filter to extract the data to a second sheet,
where you have entered your 2 dates.
Create the graph based upon the second sheet.

For more information on Advanced Filter, take a look at Debra
Dalgleish's site
http://www.contextures.com/xladvfilter01.html#ExtractWs
--
Regards

Roger Govier


"Rachel" wrote in message
oups.com...
Hi,

I am working on an attrition report and want to be able to select a
range of data dependant on the users input. For example ask the user
to specify a start and end date, which would then select the rows that
are between these dates. (eg For all people who work in left between
1/3/07 and 1/4/07) This selected range would then automatically update
a graph to show attrition reports between certain dates.

Any help would be greatly apprciated

x