nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to set different Spec lines for different projects in the graph builder

AlphaColt356

How to set different Spec lines for different projects in the graph builder， like this.

Example.xlsx

Accepted answers

txnelson

Here is a partial script to solve what you want. I have only displayed 2 of the Spec limits lines, but the addition of the other lines is just a repeat of the JSL, just changing the coordinates and text.

Names Default To Here( 1 );
dt = Current Data Table();
gb = Graph Builder(
	Size( 528, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :Label ), Y( :Data ), Color( :Label ) ),
	Elements( Box Plot( X, Y, Legend( 11 ) ), Contour( X, Y, Legend( 12 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Data",
			ScaleBox,
			{Format( "Best", 12 ), Min( -86.4411315121441 ), Max( 58.2086540147458 ), Inc( 20 ),
			Minor Ticks( 1 )}
		)
	)
);
Report( gb )[framebox( 1 )] << add graphics script(
	Pen Color( "blue" );
	Line( [-.5 .5], [-45 -45] );
	Text( {-.45, -40, 0, -42}, "LCL -45" );
	Line( [.5 1.5], [-50 -50] );
	Text( {.55, -45, 1, -47}, "LCL 50" );
);

All comments

txnelson

Names Default To Here( 1 );
dt = Current Data Table();
gb = Graph Builder(
	Size( 528, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :Label ), Y( :Data ), Color( :Label ) ),
	Elements( Box Plot( X, Y, Legend( 11 ) ), Contour( X, Y, Legend( 12 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"Data",
			ScaleBox,
			{Format( "Best", 12 ), Min( -86.4411315121441 ), Max( 58.2086540147458 ), Inc( 20 ),
			Minor Ticks( 1 )}
		)
	)
);
Report( gb )[framebox( 1 )] << add graphics script(
	Pen Color( "blue" );
	Line( [-.5 .5], [-45 -45] );
	Text( {-.45, -40, 0, -42}, "LCL -45" );
	Line( [.5 1.5], [-50 -50] );
	Text( {.55, -45, 1, -47}, "LCL 50" );
);

jthi

If you can add limits to your data this way:

you can add second graph to graph builder. If you want labels I think float bar chart is easiest (but try other visualizations also!). Building these can be sometimes a bit annoying, but the important parts are highlighted here:

Building the graph this way does have its benefits especially if you have local data filters

CompleteLeopard

How to change the line width?

Line( [-.5 .5], [-45 -45] );