Macro that graphs based on user input

[iambalrog]

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!!!

[iambalrog]

Someone must have some ideas where to start? Please!

[BN-CD]

You will need to change the graph used to the graph you need but this will give you a basic line graph where the user selects the data to be used.

Basically you should be able to use the application input box for the selection of the data to be used on the graph. So if you need a different type of graph you could use the record macro function, make the correct graph type, then look at the code to see where the data is selected and replace that with the "myCell" range.

Please Login or Register  to view this content.

[iambalrog]

That really really helped - thakyou very much for your assistance!