Categorical X scale ordering by continous Y scale on graph builder

nac

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

Performance trend analysis.jmp

ian_jmp

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

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: