control chart

Fixing a Control Chart


I’m trying to elevate my control chart to the ‘next level’ by applying the Nelson 5 statistical rules. In other words, I want to be able to highlight the points on the graph that display the Nelson statistical rules. Would you be able to help assist?

4 thoughts on “Fixing a Control Chart

  1. The way I do this is to add a column where you test each rule (so I like helper columns, I like things to work). A formula in each column returns TRUE if the rule has been broken. You can either add one series to the chart for each rule and format each differently (to identify which rules were broken where), or add one final column which is true if any of the rules were broken and plot just this column.

    Use slightly larger markers for the added data, and give them a color that draws attention.

  2. Would you be able to post an edited data set just with the points and standard deviation? It would be easier to make suggestions and show what we mean without having to recreate the data.

Leave a Reply to Jon Peltier Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>