Date Scroll Bar in Excel 2003

[ajay_gajree]

Hi All,

I have a dynamic line graph set up in Excel 2003.

The X and Y variables are set up as Data Validation lists, and depending on what is selected I retrieve my data using vlookup.

Layout of the spreadsheet is below

Cell A1: Client(Y): Client 1, 2, 3 etc (In Dropdown List pointing to a named range)
Cell A2: Date (X): 25/07/2011, 22/07/2011, 21/07/2011 etc

Table underneath this,

Client Date Data
Client A (=A1) =A2 =VLOOKUP(CONCATENATE
(B5,A5), 'Sheet1'A1:L1000,5,False)
Client A (=A1) =WORKDAY(B5,-1)
Client A (=A1) =WORKDAY(B6,-1)

I add new data to this sheet each day that will bring in the next business day, I would like add a scrollbar to to define how many days I increase the date range from the selected business day in Cell A2.

At the moment the chart is fixed to show 5 business days on the chart from the selected date in A2 and the previous 4 working days. I would like to give the user the choice as to whether they want to look at this for 5 days or 10 days or the current month, ie what ever length of time they wish to go back.

Hope I haven;t rambled on too much!

Thanks in advance for your assistance