topic Re: How to use different labels for the same bar chart? in Discussions

How to use different labels for the same bar chart?

lala — Sat, 19 Oct 2024 13:55:15 GMT

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 ) )
			)}
		)
	)
);

Re: How to use different labels for the same bar chart?

jthi — Sat, 19 Oct 2024 14:18:20 GMT

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

Re: How to use different labels for the same bar chart?

lala — Fri, 25 Oct 2024 02:19:18 GMT

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 ) )
			)}
		)
	)
);

Re: How to use different labels for the same bar chart?

jthi — Fri, 25 Oct 2024 03:59:39 GMT

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

Re: How to use different labels for the same bar chart?

lala — Fri, 25 Oct 2024 07:50:35 GMT

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!

Re: How to use different labels for the same bar chart?

jthi — Fri, 25 Oct 2024 08:24:20 GMT

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