The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Sorting X with corresponding Y-values

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
neutrondude Posted - 04/04/2013 : 1:45:00 PM
Hi,

we have some data that are not sorted correctly. I.e. the X-values are not in ascending or descending order. Is it possible to sort the dataset automatically such that the corresponding Y values are moved WITH their X-values??

Thanks a lot in advance!


Origin Ver. and Service Release (Select Help-->About Origin): XP
Operating System: 8.0
1   L A T E S T    R E P L I E S    (Newest First)
meili_yang Posted - 04/04/2013 : 3:42:31 PM
Hi,

Try the following,

Select the column you want to sort, then go to "Worksheet"-"Sort Range"-"Custom". A dialog will ask you to ascending or descending data. Then click on the column and choose how you want to sort the data.

Don't forget to choose to sort the "Entire Worksheet" on the bottom of the dialog, then corresponding Y values are moved with their X values.

Hope it can help.



Meili
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000