topic Re: Changing Months From Alphabetical To Chronological Order in Discussions

Changing Months From Alphabetical To Chronological Order

jkimmich — Tue, 15 Oct 2019 13:19:29 GMT

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!

Re: Changing Months From Alphabetical To Chronological Order

Mark_Bailey — Tue, 15 Oct 2019 13:37:33 GMT

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?

Re: Changing Months From Alphabetical To Chronological Order

jkimmich — Tue, 15 Oct 2019 13:47:22 GMT

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.

Re: Changing Months From Alphabetical To Chronological Order

txnelson — Tue, 15 Oct 2019 14:37:00 GMT

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.

Re: Changing Months From Alphabetical To Chronological Order

jkimmich — Tue, 15 Oct 2019 15:38:49 GMT

Thanks for the help!