Graph design

[rjplante]

I have a data table that I would like to write a macro to generate a Levey-Jennings style chart on it, one that displays the data line plus a line for the mean and two lines which represent +/-2SD on the plot.

I have a macro started that when the user selects the column and runs the macro the body of data is selected and the mean and 2SD is calculated and placed in a couple of cells on the worksheet.

My goal is to have rest of the macro generate the chart which would appear in a new tab in the workbook. Is it possible to get this type of chart with corresponding lines drawn in for mean and 2SD? If so how do I do it? It would also be nice to have separate colors for the data plot, mean, and 2SD lines.

Thanks for the help,

Robert

 

[Claymationator]

Give this link a try:

http://peltiertech.com/Excel/Charts/RunChtLines.html

Hope that helps.