cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
djhanson
Level V

Table Column Headers - possible to make vertical?

Hi, Is there any way to change a table report's column headers from horizontal to vertical alignment?  (like Excel can)


For example, working with a dt with a <<Get As Report or working with a Tablebox() with associated String Col Box() and Number Col Box() commands.  If possible, this would save a ton of space for viewing purposes on larger tables. (i.e. saving the table report as a PNG, etc)
Else, column headers tend to wrap the table way too much to the right making it more difficult to view. (while the value contents have a ton of white space so condensing them is fine)

 

thanks, DJ

2 REPLIES 2

Re: Table Column Headers - possible to make vertical?

Not as far as I can tell.

Byron_JMP
Staff

Re: Table Column Headers - possible to make vertical?

I'm pretty sure the answer is no too, and here's why.

 

If you run this script, you'll get a list of properties and none of them can be set to vertical orientation.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Select Where( :Age < 14 );
dt << Select Columns( :name, :age, :height );
jmp_report = New Window( "Big Class",
	Text Box( "Big Class" ),
	H List Box( Outline Box( "Big Class", dt << Get As Report ) ),
);
jmp_report<<get properties;

If this is bad news, head over to the wish list and make a suggestion

 

Alternatively, just transpose the table to get this

Screen Shot 2020-02-24 at 11.47.37 AM.png

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp",invisible );
Column( dt, "height" ) << set name(
	"Super long column name that tends to cause trouble"
);
Column( dt, "weight" ) << set name(
	"Terrible, horrible, no-good, very bad long column name"
);
dtsub = dt << Subset(
	Selected Rows( 0 ),
	Rows( [1, 2, 3, 4, 5, 6, 7, 8] ),
	Selected columns only( 0 ),invisible
);close(dt,nosave);
dtsubxp = dtsub << Transpose(
	columns( Column( 4 ), Column( 5 ) ),
	Label( :name ),
	Label column name( "name" ),
	Output Table( "Transpose of Subset of Big Class" )
);close(dtsub,nosave);

Column( dtsubxp, 1 ) << Set Display Width( 440 );
obj = dtsubxp << get as report;
dtsubxp << journal;
JMP Systems Engineer, Health and Life Sciences (Pharma)

Recommended Articles