If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Options
Excel issues
Former Member
Posts: 1,876,323 The Mix Honorary Guru
in General Chat
Ok, so I'm trying to work with some data in excel just now.
It's in the format as follows:
word f1 f2
that 546 1789
bag 645 1435
cat 735 1265
arm 578 1467
And so on.
At the moment, I'm trying to get the words in alphabetical order, but with their associated f1 and f2 values attached to them. But when I go to 'sort', all my data points move in the graph. Now, this shouldn't happen, since the data points will still have the same coordinates, no? If anyone can shed some light on this, I'd be eternally grateful. If it's not clear, let me know and I can try and be more explicit.
Thanks.
It's in the format as follows:
word f1 f2
that 546 1789
bag 645 1435
cat 735 1265
arm 578 1467
And so on.
At the moment, I'm trying to get the words in alphabetical order, but with their associated f1 and f2 values attached to them. But when I go to 'sort', all my data points move in the graph. Now, this shouldn't happen, since the data points will still have the same coordinates, no? If anyone can shed some light on this, I'd be eternally grateful. If it's not clear, let me know and I can try and be more explicit.
Thanks.
0
Comments
although the data is in rows, you need to specify that the f1 and f2 are the x and y coordinates for a given point, but I'm not quite sure how you do that I'm afraid.
had a little play with excel myself, will post again if I come up with anything
Thanks for trying replicant