Cell Plot/Graph Builder Sorting

O_Lippincott

Hi,

 

A customer would like to create a cell plot like the attached graph with the first symptom sorted by severity then the rest of the symptoms sorted accordingly. I am able to recreate the graph in graph builder using histogram except for the sorting on the first symptom only. Does anyone have any suggestions on creating the sorting in either graph builder or cell plot? I have attached the  simulated dataset as well. 

 

Thanks,

Olivia

 

cell plot data.jmp

Chris_Kirchberg

Hi Olivia,

 

You can use the Cell Plot under Graph Menu, but you would have to split the columns first.  Then you can sort within the graph by right-clicking on each column

 

Here is a script from the Scripting Index that shows that sorting can be scripted to the data table if needed.

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/SAT.jmp" );
New Window( "Example",
	cp = Cell Plot(
		Scale Uniformly( 0 ),
		Center at zero( 0 ),
		Y(
			:Name( "2004 Verbal" ),
			:Name( "2004 Math" ),
			:Name( "2003 Verbal" ),
			:Name( "2003 Math" ),
			:Name( "2002 Verbal" ),
			:Name( "2002 Math" ),
			:Name( "2001 Verbal" ),
			:Name( "2001 Math" ),
			:Name( "1999 Verbal" ),
			:Name( "1999 Math" ),
			:Name( "1994 Verbal" ),
			:Name( "1994 Math" ),
			:Name( "1997 Verbal" ),
			:Name( "1997 Math" ),
			:Name( "1992 Verbal" ),
			:Name( "1992 Math" )
		)
	)
);
cpr = cp << report;
cpb = cpr[Cell Plot Box( 1 )];
cpb << Sort Ascending;