cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
lwx228
Level VIII

How to change the classification of Y axis?

Hello!

For example, use this data table to map and categorize by country.
How to implement the Y-axis country sorting order is in the original order in the table?

dt=Open("$SAMPLE_DATA/PopAgeGroup.jmp");

2022-07-15_15-54-46.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
David_Burnham
Super User (Alumni)

Re: How to change the classification of Y axis?

Ordering by table order only makes sense if the column is sorted.  In graph builder you can right click on the axis and choose order by, and then select 'Country, ascending' or 'Country, descending'.  If the ordering is something other than sort order then probably you need to resort to the Value Ordering property.

-Dave

View solution in original post

3 REPLIES 3
jthi
Super User

Re: How to change the classification of Y axis?

Use Value Order column property or maybe create new sorting column by using Col Min(Row(), :groupcolumn).

-Jarmo
David_Burnham
Super User (Alumni)

Re: How to change the classification of Y axis?

Ordering by table order only makes sense if the column is sorted.  In graph builder you can right click on the axis and choose order by, and then select 'Country, ascending' or 'Country, descending'.  If the ordering is something other than sort order then probably you need to resort to the Value Ordering property.

-Dave

Re: How to change the classification of Y axis?

See Row Order property as well.