Combo Chart, Add lower & Upper Spec Limit problems

Bernieg

Board Regular
Joined
Jan 1, 2009
Messages
147
Office Version
  1. 365
Platform
  1. Windows
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.

Combo Chart with Scatter Chart.xlsm
ABCDEFGHIJKLMNOP
1Idevidual Data5
28 BinsØ1288.3 ± 0.05 Flange Before
30.0125Ø1288.3 ± 0.05 Flange BeforeLSL, 1288.25FrequencyDistribution CurveUSL, 1288.35Interval(Scores)Midpoint X
4Nominal1288.3501288.250
5Upper Tol1288.35031.15201288.2421288.2551288.248
6Lower Tol1288.25011.78501288.2551288.2671288.261
7ULS0.05052.50301288.2671288.2801288.273
8LSL-0.05013.17501288.2801288.2921288.286
9n30033.64501288.2921288.3051288.298
10Cpk0.284013.78501288.3051288.3171288.311
11Cp0.348033.55501288.3171288.3301288.323
12Z st0.851053.02201288.3301288.3421288.336
13P-Value0.171967244032.32301288.3421288.3551288.348
14Mean1288.3092021.61601288.3551288.3671288.361
15StDev(Overall)0.0395021.01701288.3671288.3801288.373
16StDev(within)0.0479051288.350
17M/R (UCL)0.1766
18M/R (Mean)0.054
19PPM(ST)166666.6667
20PPM(LT)218300
Before
Cell Formulas
RangeFormula
A2A2=ROUNDUP(POWER($B9,1/3)*2,0)+1
E5E5=SUMPRODUCT((Imrdata>=I5)*(Imrdata<=J5))
F5:F15F5=NORM.DIST(K5,B$14,B$15,FALSE)*B$9*A$3
E6:E15E6=SUMPRODUCT((Imrdata>I6)*(Imrdata<J6))
Named Ranges
NameRefers ToCells
Imrdata=Before!$B$21:$B$50E5:E15
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A11:A12Cell ValueduplicatestextNO
A11:A12Cell ValueduplicatestextNO
A11:A12Cell ValueduplicatestextNO
 

Attachments

  • Before Combo Chart.jpg
    Before Combo Chart.jpg
    153.4 KB · Views: 4

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top