Hi

I have no idea where to start...but i want to try and build a macro that will graph a data set based on user input.
The graph would be a standard line chart with just a couple of series, and the data would come from a specifc location and be pre populated. It would be along the lines of:
Week Commencing
Deliveries for customer A
Deliveries for customer B

The aspect i want the user to be able to influence is the start/end date of the period the graph will cover.
I was thinking if the user entered a wk commencing date, some sort of lookup could find that date in the series and order the macro to build a graph on the data offset below that.

Help!!!