Hi I am struggling to sort data on the x axis within control chart builder and via the IMR Control Chart . In the example attached I drag the X variable of 95 values, I deliberately reverse 90 and 91 in the data set, but on a control chart it keeps it 91 then 90.
In graph builder it allocates the correct run order of 90, 91.
I have tried value ordering and this does not seem to work - I played around with different data formats but nothing seemed to work for me

I know I can sort data and then it works but I dont want to keep sorting columns - my data table is massive, I rather rely upon a column with correct order to assess the data