Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted

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?

Learn it once, use it forever!
Highlighted
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 

Highlighted
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

Highlighted
jkimmich
Level I

Re: Changing Months From Alphabetical To Chronological Order

Thanks for the help!  

Article Labels

    There are no labels assigned to this post.