Making an out of control process look different in SPC chart

**blake.b.8726** · 03-03-2015, 12:17 AM

So I have a set of data and if there are seven points that are all above or below the mean, then the process is said to be out of control. I would like to find a way to make those seven points stand out on a line graph.

**Andy Pope** · 03-03-2015, 04:44 AM

Add another series that is based on formula where only out of control data points are displayed. The in control data points are given the result of the NA() function.
You can then format this series as requried.

**blake.b.8726** · 03-03-2015, 12:38 PM

I did that, but if seven points in a row are all above or below the mean, then I need all seven points to stand out.

**Andy Pope** · 03-03-2015, 12:40 PM

Not sure I understand what you mean.

Can you post example file of what you have done

**blake.b.8726** · 03-03-2015, 08:23 PM

Here is workbook that is very close to what I am dealing with. I put an explanation in it of what I am thinking.Color Example.xlsx

**Andy Pope** · 03-04-2015, 04:38 AM

You are already using the technique to highlight above/below CL. What you need now is a formula to output values for above/below Average.

Your problem is more a forumla, possible VBA. Post a revised question in the formula section on how to get values, rather than NA(), displayed for a consecutive run of values.

**blake.b.8726** · 03-04-2015, 06:42 AM

OK, thank you.

**Andy Pope** · 03-05-2015, 05:51 AM

It's not a super slick formula but it appears to work.

**blake.b.8726** · 03-05-2015, 11:26 AM

Thanks! That does work, at least on my laptop. The computers where I work only have excel 2007, but at least there a way to do it. I appreciate your hard work!