nick99
07-23-2007, 11:18 AM
I need to plot the data in the following excel file
The data is on the worksheet name ?WK?
I need a macro where there are 4 plots for the four axis LHX, LHY, RHX & RHY.
However I also need the nominal, upper and lower lines on the plot.
The name of the plot should be what the title in the column says.
Now here is the catch, the data is dynamic and the number of rows changes everyday. So I need a self adjusting range.
The title, nominal, upper and lower values could also change and consequently need to change and be depicted on the plot.
Please help!!!!
The data is on the worksheet name ?WK?
I need a macro where there are 4 plots for the four axis LHX, LHY, RHX & RHY.
However I also need the nominal, upper and lower lines on the plot.
The name of the plot should be what the title in the column says.
Now here is the catch, the data is dynamic and the number of rows changes everyday. So I need a self adjusting range.
The title, nominal, upper and lower values could also change and consequently need to change and be depicted on the plot.
Please help!!!!