cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

How to change the classification of Y axis?

lwx228
Level VIII

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.