Subscribe Bookmark RSS Feed

Categorical X scale ordering by continous Y scale on graph builder

nac

Occasional Contributor

Joined:

Feb 17, 2017

Dear all, I try to graph categorical X scale vs. continous Y scale by months. My purpose is ordering X scale by Y values. But ı do not find a way. Is there anyone can help on this? You can see graph builder at the attached jmp file. 

 

Thanks for your help in this matter

1 REPLY
ian_jmp

Staff

Joined:

Jun 23, 2011

Looks like the value ordering of 'Month' is not correctly defined:

Screen Shot 2017-07-03 at 09.43.55.png

If you delete this column propoerty, you will get the desired result. Note that the date ordering of 'Month' is not alphanumeric, but JMP is smart enough to take this into account so the column property is not needed in this special case. But you could always define it if you care to.

 

Also, FYI, you can use a nested X axis if you prefer:

Screen Shot 2017-07-03 at 09.44.51.png