VBA to draw lines of SPC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I need a simple sub VBA to draw 3 red lines of mean, upper/lower control
limits (3 sigma). How can I do that?
Thnks for your help.
Daniel
 
Thanks Andy
But I need a dynamic chart when data grow the SPC lines expand too.
I just need a macro to draw lines of mean and upper/lower 3 sigma control
lines
Thnks
Daniel
 
I guess you didn't read the article too closely. The error bars that account
for the lines stretch as the number of points in the chart increases, and
the points for the Y values of the three lines also move as the data
changes. You can make the chart series dynamic using an approach like this:

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

Using a macro is not generally the easier way to do anything involving
charts. Using a macro is less tedious to use if you have to do things
frequently, but constructing such a macro is not such a trivial exercise.

- Jon
 
Back
Top