Hi,
Currently I am plotting the control chart manualy, thinking of changing the platting into excel format which I found quite a nos of good chart posted here. My question is how can I record my correction action if there is out of control limit in the chart? All help & advise are welcome.tks

One way would be to use the comment function.
Right click on a cell and select comment form the drop down menu. Then enter your comment.

James

One way would be to use the comment function.
Right click on a cell and select comment form the drom down menu. Then enter your comment.

JamesThis is a good suggestion. I have seen it used and I llike it.

Tks for the fast response, The problem is I am using autoupdate on the excel chart with web query, the chart will refresh every 5 min, whenever there is new data update into database, the chart will show only the last 25 data in chart. So by adding the comment in the cell will not work for me, I do display the control chart in excel format, user have no access to click on chart. Anothers issue is without filling in the corrective action on out of control limit point, user will not allow to continue production or update the chart. Hope this make it more clear on what I am looking for. tks a lot.

It sounds like you what to comment directly in the chart so that others can see - is this correct? Are you looking for a way to have Excel automatically flag out-ot-control points? Or perhaps to annotate the graph with a little message like "settings adjusted here because process was drifting toward upper control limit". Or do you just want a record of the corrective action within the spreadsheet that you as QE can edit and see?

I think any of these could be done, but it would be helpful to know just what you want and how you want it displayed.

Tim F

It sounds like you what to comment directly in the chart so that others can see - is this correct? Are you looking for a way to have Excel automatically flag out-ot-control points? Or perhaps to annotate the graph with a little message like "settings adjusted here because process was drifting toward upper control limit". Or do you just want a record of the corrective action within the spreadsheet that you as QE can edit and see?

I think any of these could be done, but it would be helpful to know just what you want and how you want it displayed.

Tim F
Hi Tim,
Yes when there is a point out of limit the message will only come out when the engineer have fill in the corrective action spreadsheet. The problem is my point will keep on changing, for example point 25 out of limit, I do fill up the corrective action (No idea yet on how to do this), data 26 come in data 25 become point 24 & so on it will kick off from the chart. When an auditor look at the current chart there is no out of limit but the corrective action having an record of out of limit, is it ok? I am not sure and have no idea on how to monitor and record on the out of control limit. Any sample or recommendation are welcome.tks

Anyone help on this please....

Hope it will work.........

Control charts can be updated automatically by using moving ranges in the data section of your spreadsheet. You can write truth tables in adjacent columns (or rows) to identify “out-of-control” points (such as 2 out of 3 consecutive points outside the 2 sigma, 2σ – not 2s, limits. These can then combined to identify any point “out-of-control”. Place the non-conformance comment in the same row (or columns). You can then use Rob Bovey’s XY Chart Labeler to add the comments to the graph and have them move with your moving range data.

Ref. John Walkenbach web site for moving range charts, Rob Bovey’s Application Professionals web site for the XY Chart Labeler, and Jon Peltier’s Peltier Technical Services web site for other charting techniques.


Joe Adams

... Ref. John Walkenbach web site for moving range charts, Rob Bovey’s Application Professionals web site for the XY Chart Labeler, and Jon Peltier’s Peltier Technical Services web site for other charting techniques.
Joe AdamsThanks Joe.
Would these be:

John Walkenbach web site for moving range charts (http://search.barnesandnoble.com/Excel-VBA-Programming-for-Dummies/John-Walkenbach/e/9780764574122): Excel VBA Programming for Dummies

Rob Bovey’s Application Professionals web site for the XY Chart Labeler (http://www.appspro.com/Utilities/ChartLabeler.htm):
XY Chart Labeler is a free utility.

Jon Peltier’s Peltier Technical Services web site for other charting techniques (http://peltiertech.com/)

Would these be:

John Walkenbach web site for moving range charts (http://search.barnesandnoble.com/Excel-VBA-Programming-for-Dummies/John-Walkenbach/e/9780764574122): Excel VBA Programming for DummiesNo, I would use John’s website: http://spreadsheetpage.com (http://spreadsheetpage.com/)

John has written books for each version of MS Excel, and if you use Excel 2003, I would recommend:
http://spreadsheetpage.com/index.php/book/excel_charts/

http://spreadsheetpage.com/index.php/book/john_walkenbachs_favorite_excel_tips_tricks/

http://spreadsheetpage.com/index.php/book/excel_2003_formulas/



Would these be:

Rob Bovey’s Application Professionals web site for the XY Chart Labeler (http://www.appspro.com/Utilities/ChartLabeler.htm):
XY Chart Labeler is a free utility.Yes
You might be able to use an add-in tool from John Walkenbach to identify “out-of-control” points on the chart:
http://spreadsheetpage.com/index.php/file/j_walk_chart_tools_add_in


Would these be:

Jon Peltier’s Peltier Technical Services web site for other charting techniques (http://peltiertech.com/)
Yes
Specific areas to study would be:

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

http://peltiertech.com/Excel/Charts/statscharts.html#CtrlCht

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

http://peltiertech.com/WordPress/dynamic-charts/

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



Joe Adams