I want to sort the x column of data set in ascending order while keeping the corresponding y value of each x point next to it. I do this in usual manner: highlighting A(X1) and B(Y1) analysis > sort columns > custom > highlighting A(X1) > ascending
Only the A(X1) column is sorted. Any idea why? Any complains about this before?
Could you active the data and use the menu item analysis > sort worksheet > custom > highlighting A(X1) > ascending Then the corresponding y value will be changed with X.