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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Workbook to XYZ/Matrix if X and Y are both in rows		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

nled

Germany
1 Posts
Posted - 02/26/2016 :  11:20:52 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I want to transform a XYZ data into matrix.

When I try to convert it into matrix, it tells me, x is rows and y is collums. How do I convert it if they are both in rows?

Here is a more detailed clarification:

what i have
X Y Z1 Z2 Z3 ....
30 1 123
31 1 136
32 1 122
28 2 333
29 2 222
30 2 111
...
etc

What I want to get in order to make a surface plot out of it:

00000001110000000
00000011111100000
00000111111110000
00111111111111100

where 1 is a Z1 value


I think I have already solved this problem in the past, but It seems I have totally forgot how to do it.

Thank you very much.
Edited by - nled on 02/26/2016 11:22:25 AM

snowli

USA
1381 Posts
Posted - 02/26/2016 :  3:14:47 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
If your data are organized as in 3 columns. First column X, 2nd Y and 3rd Z,
Please set the 3rd column as Z and then choose Worksheet: Convert to Matrix: XYZ Gridding... to convert it into matrix.

Actually Origin supports plotting 3D data directly from XYZ columns in worksheet. So you can highlight the Z column (must be set as Z) and then plot: 3D Surface: and pick the plot type you want.

Thanks, Snow
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000