Hello:

I wanted to create a macro that would create a control chart from an Excel data set I have which shows survey score information for individuals during a time period.

The data set has 3 fields: persons name being evaluated, a survey score, and the year/month that survey was received. (Note that multiple surveys can happen in a given month).

I would like to be able to run a macro that will evaluate the data, by individual, and create a control chart showing their score, upper control limit (UCL), lower control limit (LCL) and mean, by month. The title would need to show their name and the date range of the surveys being evaluated.

I looked at some off the shelf software and macros, and even those would require a lot of manual input to create them, so I think a customized macro is the way to go.

I would greatly appreciate it if someone could provide some guidance and asssitance towards doing this.

Many thanks in advance-
Ebachenh