Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA to draw lines of SPC
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA to draw lines of SPC
Hi
No need for VBA. See here for suggestions on how to add datum lines to charts. http://peltiertech.com/Excel/Charts/RunChtLines.html Cheers Andy Daniel wrote: 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA to draw lines of SPC
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 "Andy Pope" wrote: Hi No need for VBA. See here for suggestions on how to add datum lines to charts. http://peltiertech.com/Excel/Charts/RunChtLines.html Cheers Andy Daniel wrote: 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA to draw lines of SPC
And.
The lines are based on the charted data so the values will change when the data changes. If you draw lines you will need to run vba each time. Jon has pages for dynamic data in charts http://peltiertech.com/Excel/Charts/Dynamics.html But if you really must draw over the chart this may help. http://peltiertech.com/Excel/Charts/VBAdraw.html Cheers Andy Daniel wrote: 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 "Andy Pope" wrote: Hi No need for VBA. See here for suggestions on how to add datum lines to charts. http://peltiertech.com/Excel/Charts/RunChtLines.html Cheers Andy Daniel wrote: 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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
VBA to draw lines of SPC
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/...umnChart1.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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... 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 "Andy Pope" wrote: Hi No need for VBA. See here for suggestions on how to add datum lines to charts. http://peltiertech.com/Excel/Charts/RunChtLines.html Cheers Andy Daniel wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to draw trend lines through only certain data points | Charts and Charting in Excel | |||
draw different weight lines depending on the cell value | Excel Discussion (Misc queries) | |||
Inserting Lines or Copying lines with formulas but without data | Excel Discussion (Misc queries) | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel |