cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
jkimmich
Level I

Changing Months From Alphabetical To Chronological Order

I have a data set with a column of months that are ordered chronologically.  When I create a graph in graph builder, the months show up alphabetically on the axis.  I would like to change it to the same order in my data set (chronological, not alphabetical).  Any help for this jmp rookie would be greatly appreciated!  Thank you! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Changing Months From Alphabetical To Chronological Order

Because your rows are in the order you want your chart, you can simply handle this by turning on the "Row Order Levels" Column Property for your "Year/Mo" column.
To do this, move your cursor to the column header for the "Year/Month" column. Right click and select
Column Properties==> Row Order Levels.
The order of the axis for any charts you make for that column, will then be in the order the data are in the data table.
Jim

View solution in original post

4 REPLIES 4

Re: Changing Months From Alphabetical To Chronological Order

I assume that the data column that stores the months is defined for character data. JMP will generally order character strings alphanumerically. The months of the year, though, are a special case that is automatically recognized when the values are stored as the complete name (e.g., October) or the three-letter abbreviation (e.g., Oct). How are you storing the month data?

jkimmich
Level I

Re: Changing Months From Alphabetical To Chronological Order

Thanks for your help.  Here's a pic of my data set.  It is the column Year/Mo that I am trying to get to show chronologically in graph builder.  Screenshot (9).png 

txnelson
Super User

Re: Changing Months From Alphabetical To Chronological Order

Because your rows are in the order you want your chart, you can simply handle this by turning on the "Row Order Levels" Column Property for your "Year/Mo" column.
To do this, move your cursor to the column header for the "Year/Month" column. Right click and select
Column Properties==> Row Order Levels.
The order of the axis for any charts you make for that column, will then be in the order the data are in the data table.
Jim
jkimmich
Level I

Re: Changing Months From Alphabetical To Chronological Order

Thanks for the help!