charts

[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 mean and SD lines on the plot along with the actual data line. My goal is to have the user select the column of interest and then click a button to 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 SD? If so how do I do it? It would also be nice to have separate colors for the data plot, mean, and SD lines.

Thanks for the help,

Robert