cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
yummy
Level I

How to Highlight some distributions in graph

yummy_0-1623140040293.png

Hello:) The figure above is a part of my question. As you can see at the picture, I want to highlight some elements whose Cpk is smaller than 1.

Somebody help me.. Thank you in advance:)

 

1 REPLY 1
Thierry_S
Super User

Re: How to Highlight some distributions in graph

Hi,

Assuming that your data is in stacked format (i.e., Ys = Data are all in 1 column and the Xs = Label are in a second column), create a new column of Row State type and enter the formula below:

If(
	Col Mean( :Data, :Label ) - Col Std Dev( :Data, :Label ) * 3 < :Data <=
	Col Mean( :Data, :Label ) + Col Std Dev( :Data, :Label ) * 3,
	Color State( "red" ),
	Color State( "black" )
);
:FORMAT << Copy to Row States();

You can easily fine tune the range of CPK by modifying the Std Dev multipliers (here set to 3 sigma).

 

I hope this helps.

 

Best,

 

TS

Thierry R. Sornasse