topic Re: Use order of the first axis in control charts in Discussions

Use order of the first axis in control charts

SophieCuvillier — Thu, 13 Nov 2025 15:52:55 GMT

Hello,

I'm doing a control chart (see attached table script) where I display my values ('Value') in a specific order ('Order'). 'Order' is my subgroup. But I'd like to add a label to the axis, for example, 'Quarter - Year'. The problem is that this changes the data order. I'd like to use the order specified in the first subgroup, but keep 'Quarter Year' displayed at the bottom. How can I do this?

I know I could customize the order of my Quarter Year column, but within the same quarter, that doesn't guarantee the correct order.

Expected (right order)

Obtained (wrong order)

Re: Use order of the first axis in control charts

Jed_Campbell — Thu, 13 Nov 2025 15:58:52 GMT

Which version of JMP are you using? JMP 19 made some changes to the default behavior, and the script on the data table supplied looks (I think?) how you want without any changes:

Re: Use order of the first axis in control charts

Ben_BarrIngh — Thu, 13 Nov 2025 16:02:09 GMT

Hi @SophieCuvillier ,

What version of JMP are you using? I just tried your script on v19.0.1. and it came out in the right order:

Thanks,
Ben

Re: Use order of the first axis in control charts

SophieCuvillier — Thu, 13 Nov 2025 16:04:00 GMT

It is JMP 18.1.1 , I can't use JMP 19 yet as the client had not migrated to the latest version yet

Re: Use order of the first axis in control charts

jthi — Thu, 13 Nov 2025 16:17:01 GMT

These work at least with JMP18.

Try adding Vale Order column property to your QUARTER-YEAR (Q3/Q4-2024 are in wrong location)

Other option (which I would not suggest) is to add second Order column to your X-axis and then hide it

Re: Use order of the first axis in control charts

SophieCuvillier — Fri, 14 Nov 2025 17:10:44 GMT

Hello,

Thank you for your answer! The problem is that I've noticed that even if I add a 'value order' property column to the QUARTER YEAR axis, it doesn't necessarily sort the values within the same quarter in the correct order; it doesn't always take into account the order below (even if the axis below has also a column property).

So I was interested in your second option, but in JSL I can't achieve to add the same value to a duplicate axis; it automatically deletes it. I can only do it by dragging and dropping.

Re: Use order of the first axis in control charts

jthi — Fri, 14 Nov 2025 17:58:42 GMT

Maybe you have to add value order to both of the columns?

If it will automatically remove it, create "temporary" column which copies the values of the column you wish to duplicate and then use that as x-axis

Re: Use order of the first axis in control charts

SophieCuvillier — Tue, 18 Nov 2025 09:17:20 GMT

Hello it was a mistake on my side in my data (not the ones from reprex), if both columns havee order property it works thank you