Remove percentage sign in Graph Builder

Question

Hi -

I am interested in removing redundant % sign in the graph generated with graph builder since Y axis already has it. This would help with space when I have too many bars.

How can I remove percentage sign that is highlighted in red?

I am using Jmp 12.2

Thank you!

laura_archer · Answer

Here is a solution for newer versions of JMP

We can start with the same example as the previous post

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt << New Column( "percent", Format( "percent", 12, 1 ), formula( :Height / :Weight ) );
gb = Graph Builder(
	Size( 528, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :sex ), Y( :percent ) ),
	Elements( Bar( X, Y, Legend( 6 ) ) )
);

Then in Graph Builder choose Label -> Label By Value.  This will show the extra % symbol
Under Label Format, click on the Auto dropdown (twice) and choose a new format.  One option would be best or fixed dec, but this will show the format as a decimal value

To get that value * 100, but without the percent symbol click on the dropdown again and choose Custom
Click Set Custom Format
The formula editor will open with the word value in the middle.  Click the multiplication button and then type 100

Click OK

hogi · Answer

@ian_jmp 
Doesn't the screenshot shows how to remove the label?

How to remove the percentage sign of the label in the current Jmp version?

txnelson · Answer

The only way that I think you can do what you want is to add the labels by writing some simple JSL.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt << New Column( "percent", Format( "percent", 12, 1 ), formula( :Height / :Weight ) );
gb = Graph Builder(
	Size( 528, 448 ),
	Show Control Panel( 0 ),
	Variables( X( :sex ), Y( :percent ) ),
	Elements( Bar( X, Y, Legend( 6 ) ) )
);
gbr = gb << report;
flist = {.0};
Insert Into( flist, Round( Col Mean( If( :sex == "F", :percent, . ) ), 3 ) );
f = Char( flist[2] * 100 );
mlist = {1};
Insert Into( mlist, Round( Col Mean( If( :sex == "M", :percent, . ) ), 3 ) );
m = Char( mlist[2] * 100 );
gbr[framebox( 1 )] << Add Graphics Script(
	Text( Center Justified, flist, f );
	Text( Center Justified, mlist, m );
);