topic Remove percentage sign in Graph Builder in Discussions

Remove percentage sign in Graph Builder

uProf — Fri, 28 Jan 2022 21:40:57 GMT

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!

Re: Remove percentage sign in Graph Builder

ian_jmp — Mon, 31 Jan 2022 12:56:41 GMT

Sorry, I don't have that version to hand. But, if it helps, in the current version theres an option:

Re: Remove percentage sign in Graph Builder

txnelson — Mon, 31 Jan 2022 15:25:28 GMT

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

Re: Remove percentage sign in Graph Builder

hogi — Thu, 15 Jun 2023 18:24:08 GMT

@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?

Re: Remove percentage sign in Graph Builder

laura_archer — Wed, 21 Jun 2023 17:35:52 GMT

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