VBA to draw lines of SPC

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
 
G

Guest

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
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create SPC chart with 3 sigma Upper/Lower control limit 3
How do I easily draw in Excel the Upper and Lower limits of a con. 3
How to add Upper/lower control limit lines to a graph (not drawn) 2
Chart automation with entry data 4
How do I draw a floating cluster Gantt Chart with VBA. 1
Auto Scaling of Y-axis 5
Intersection of two lines 5
Convert Error Bars to Series and Colour 1

Top