| T O P I C R E V I E W |
| nled |
Posted - 02/26/2016 : 11:20:52 AM
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. |
| 1 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 02/26/2016 : 3:14:47 PM
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 |
|
|
