Hi I'm trying to add Lower & Upper Spec Limits to a Combo Chart.
If the data is between LSL & USL then all Ok.
However if the data is between & inside/outside LSL & USL the chart X axis is wrong.
How do i get LSL & USL in the correct X axis position
Thanking you in Advance
Bernie
Thought about changing to LSL & USL to Scatter, but could not get it to work.
If the data is between LSL & USL then all Ok.
However if the data is between & inside/outside LSL & USL the chart X axis is wrong.
How do i get LSL & USL in the correct X axis position
Thanking you in Advance
Bernie
Thought about changing to LSL & USL to Scatter, but could not get it to work.
Combo Chart with Scatter Chart.xlsm | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Idevidual Data | 5 | ||||||||||||||||
2 | 8 Bins | Ø1288.3 ± 0.05 Flange Before | ||||||||||||||||
3 | 0.0125 | Ø1288.3 ± 0.05 Flange Before | LSL, 1288.25 | Frequency | Distribution Curve | USL, 1288.35 | Interval | (Scores) | Midpoint X | |||||||||
4 | Nominal | 1288.3 | 5 | 0 | 1288.250 | |||||||||||||
5 | Upper Tol | 1288.35 | 0 | 3 | 1.152 | 0 | 1288.242 | 1288.255 | 1288.248 | |||||||||
6 | Lower Tol | 1288.25 | 0 | 1 | 1.785 | 0 | 1288.255 | 1288.267 | 1288.261 | |||||||||
7 | ULS | 0.05 | 0 | 5 | 2.503 | 0 | 1288.267 | 1288.280 | 1288.273 | |||||||||
8 | LSL | -0.05 | 0 | 1 | 3.175 | 0 | 1288.280 | 1288.292 | 1288.286 | |||||||||
9 | n | 30 | 0 | 3 | 3.645 | 0 | 1288.292 | 1288.305 | 1288.298 | |||||||||
10 | Cpk | 0.284 | 0 | 1 | 3.785 | 0 | 1288.305 | 1288.317 | 1288.311 | |||||||||
11 | Cp | 0.348 | 0 | 3 | 3.555 | 0 | 1288.317 | 1288.330 | 1288.323 | |||||||||
12 | Z st | 0.851 | 0 | 5 | 3.022 | 0 | 1288.330 | 1288.342 | 1288.336 | |||||||||
13 | P-Value | 0.171967244 | 0 | 3 | 2.323 | 0 | 1288.342 | 1288.355 | 1288.348 | |||||||||
14 | Mean | 1288.3092 | 0 | 2 | 1.616 | 0 | 1288.355 | 1288.367 | 1288.361 | |||||||||
15 | StDev(Overall) | 0.0395 | 0 | 2 | 1.017 | 0 | 1288.367 | 1288.380 | 1288.373 | |||||||||
16 | StDev(within) | 0.0479 | 0 | 5 | 1288.350 | |||||||||||||
17 | M/R (UCL) | 0.1766 | ||||||||||||||||
18 | M/R (Mean) | 0.054 | ||||||||||||||||
19 | PPM(ST) | 166666.6667 | ||||||||||||||||
20 | PPM(LT) | 218300 | ||||||||||||||||
Before |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A2 | A2 | =ROUNDUP(POWER($B9,1/3)*2,0)+1 |
E5 | E5 | =SUMPRODUCT((Imrdata>=I5)*(Imrdata<=J5)) |
F5:F15 | F5 | =NORM.DIST(K5,B$14,B$15,FALSE)*B$9*A$3 |
E6:E15 | E6 | =SUMPRODUCT((Imrdata>I6)*(Imrdata<J6)) |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
Imrdata | =Before!$B$21:$B$50 | E5:E15 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A11:A12 | Cell Value | duplicates | text | NO |
A11:A12 | Cell Value | duplicates | text | NO |
A11:A12 | Cell Value | duplicates | text | NO |