How to use different labels for the same bar chart?

[#1]

Positive and negative values like this use different cotton swabs

Thanks!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = N Row( dt );ca = "weight";ar = dt << GetAsMatrix( ca );
For( i = 1, i <= r, i++,	ar[i, 1] = -ar[i, 1]);dt[0, ca] = ar;
c1 = Quantile( 0.8, dt[0, "height"] );c2 = Quantile( 0.2, dt[0, "weight"] );
ca = "A";New Column( ca );Column( ca ) << Formula( If( height > c1, height ) );dt << run formulas;Column( ca ) << deleteFormula;
ca = "B";New Column( ca );Column( ca ) << Formula( If( weight < c2, weight ) );dt << run formulas;Column( ca ) << deleteFormula;
Column( "A" ) << set labelled( 1 );
Column( "B" ) << set labelled( 1 );
Column( "name" ) << set labelled( 0 );
p1 = dt << Graph Builder(
	Size( 885, 607 ),
	Variables( X( Transform Column( "Row", Formula( Row() ) ) ), Y( :height ), Y( :weight, Position( 1 ) ) ),
	Elements( Bar( X, Y( 1 ), Y( 2 ), Legend( 5 ), Bar Style( "Stacked" ), Label( "Label by Row" ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Transparency( 0.5 )}, Item ID( "height", 1 ) ),
				Properties( 1, {Transparency( 0.5 )}, Item ID( "weight", 1 ) )
			)}
		)
	)
);

[#2 · Accepted solution]

You could for example add extra bar charts for A and B columns and set labels for those (disable columns from variables accordingly and set transparency of second bar charts to 0)

I think you can also use Points instead of bars in JMP18 if you want to

[#3]

I changed the label form, and I do not know how to set the label in this case.
I bother the expert to instruct again.

Thanks Experts!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
r = N Row( dt );ca = "weight";ar = dt << GetAsMatrix( ca );
For( i = 1, i <= r, i++,	ar[i, 1] = -ar[i, 1]);dt[0, ca] = ar;
c1 = Quantile( 0.8, dt[0, "height"] );c2 = Quantile( 0.2, dt[0, "weight"] );
ca = "A";New Column( ca, Character,"Nominal");Column( ca ) << Formula( If( height > c1, "A"||char(row()) ) );dt << run formulas;Column( ca ) << deleteFormula;
ca = "B";New Column( ca,Character,"Nominal" );Column( ca ) << Formula( If( weight < c2, "B"||char(row()) ) );dt << run formulas;Column( ca ) << deleteFormula;
Column( "A" ) << set labelled( 1 );Column( "B" ) << set labelled( 1 );Column( "name" ) << set labelled( 0 );
p1 = dt << Graph Builder(
	Size( 885, 607 ),
	Variables( X( Transform Column( "Row", Formula( Row() ) ) ), Y( :height ), Y( :weight, Position( 1 ) ) ),
	Elements( Bar( X, Y( 1 ), Y( 2 ), Legend( 5 ), Bar Style( "Stacked" ), Label( "Label by Row" ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				5,
				Properties( 0, {Transparency( 0.5 )}, Item ID( "height", 1 ) ),
				Properties( 1, {Transparency( 0.5 )}, Item ID( "weight", 1 ) )
			)}
		)
	)
);

[#4]

Did you try with the same method I did provide earlier? You just have to add new columns with the "heights" where you want to show the labels and and use those to create the bar charts with label enabled

[#5]

Yes, the original "A" column is positive and the "B" column is negative.So they can be shown above and below.

Now "A" and "B" are text.You cannot have the "A" column label displayed above and the "B" column label displayed below.This is the key.

Thanks!

[#6]

Did you try the method in my earlier post and try creating extra columns?

You just have to add new columns with the "heights" where you want to show the labels and and use those to create the bar charts with label enabled

---