How can i reference line change? no numeric

Song

Hi I want to put the Std mean of the two data into the reference line as shown in the graph below.

The JMP script below has I arbitrarily written the Std mean, 13.2 (22.2+4.2)/2 = 13.2

Actually the data I use is more than two. (Below image is just example)

How can i script change?

dt = Open( "$SAMPLE_DATA/Big Class.jmp" ) ;


Graph Builder(
	Size( 1056, 825 ),
	Variables( Y( :height ), Y( :weight ) ),
	Elements(
		Position( 1, 1 ),
		Points( Y, Legend( 7 ) ),
		Caption Box( Y, Legend( 13 ), Summary Statistic( "Std Dev" ) )
	),
	Elements(
		Position( 1, 2 ),
		Points( Y, Legend( 8 ) ),
		Caption Box( Y, Legend( 14 ), Summary Statistic( "Std Dev" ) )
	),
	SendToReport(
		Dispatch(
			{},
			"height",
			ScaleBox,
			{Add Ref Line( 13.3, "Solid", "Medium Dark Red", "Std Dev mean", 2 )}
		),
		Dispatch(
			{},
			"weight",
			ScaleBox,
			{Add Ref Line( 13.3, "Solid", "Medium Dark Red", "Std Dev mean", 2 )}
		)
	)
);

txnelson

As can be seen in my previous response, to Add a Reference Line, all you have to do, is to pass an << Add Ref Line message to the Axis that you want to add the reference line to:

Report( gb )[AxisBox( 2 )] << Add Ref Line( Col Std Dev( :Height ), "Solid", "Medium Dark Red", "Std Dev mean", 2 );

To find out which Axis to properly point to, one needs to look into the Tree Structure of the output from the Graph Builder.  To do this, you right click on the grey triangle next to the Graph Builder Heading and select

     Edit==>Show Tree Structure

Then you can align the Graph Window with the Tree Structure Window, and click on the item in the Graph Window that you want to see the Tree Structure for, and JMP will move to that structure in the Tree Structure Window

 

As can be seen here, the Axis for the Height column, for Sex=="F" is AxisBox(2)

If you click on each of the Axes in question you will see what Axis Box to point to to Add a Ref Line to.  The last axis of question, column Weight, for Sex=="M" is:

Now all that needs to be done is to expand on the JSL to create the Reference Lines for all 4 axes and to calculate in each of the Add Ref Line messages, the correct value for the placement of the Reference Line.  Here are the 4 Add Ref Line lines of code:

Report( gb )[AxisBox( 3 )] << Add Ref Line(
	Col Std Dev( If( :sex == "F", :Weight, . ) ),
	"Solid",
	"Medium Dark Red",
	"Std Dev mean",
	2
);
Report( gb )[AxisBox( 2 )] << Add Ref Line(
	Col Std Dev( If( :sex == "M", :Height, . ) ),
	"Solid",
	"Medium Dark Red",
	"Std Dev mean",
	2
);
Report( gb )[AxisBox( 3 )] << Add Ref Line(
	Col Std Dev( If( :sex == "M", :Weight, . ) ),
	"Solid",
	"Medium Dark Red",
	"Std Dev mean",
	2
);

Note that in this case, that the Sex column had to be taken into account for the calculation of the Standard Deviation, along with the measurement column.