| Author |
 Topic  |
|
|
nikhilts
USA
Posts |
 Posted - 02/11/2008 : 3:09:46 PM
|
Origin Version (Select Help-->About Origin): Origin Pro 8
Operating System: Win XP
Hi!
I am trying to create a 3D surface plot with the following data
X-data: 1x20 array ---- stored in column A
Y-data: 1x20 array ---- stored in column B
Z-data: 20x20 array ---- stored in columns C through V
1) I am trying to create a matrix out of the data using XYZ-gridding. But in the input data section ----> z-data range, all the columns of my 20x20 matrix are not being accepted. Only the 1st column of the matrix is being considered even though I am selecting the whole matrix using the mouse.
2) If I manually change the syntax of z-data range to
[Book2]Sheet1![C,D,E,F,G,H,I,J,K,....,V][1:20]
the matrix is not being created.
The message 'Please select one XYZ range' still appears at the bottom of the dialog box.(and also the ok button stays inactive)
Can anyone help me with this issue?
Thanks in advance. |
|
|
snowli
USA
1426 Posts |
Posted - 02/11/2008 : 3:58:55 PM
|
Hello,
For XYZ Gridding, data need to be organized in XYZ columns.
(X column, Y column, Z column).
For your data, Origin has Direction converstion for it. But you need to change the location of your X, and Y columns.
In workbook.
Put X data in first row (from column B to U)
Put Y data in colA (from row 2 to row 21)
Put Z data from col(B)[2] to col(U)[21]
Choose Worksheet: Convert to Matrix: Direct...
In the dialog that opens, set the following settings.
Data Format: X across columns
X Values in: First Row
Y Values in First Columns: Checked
Click OK.
--> Your data will be converted to Matrix
Choose View: Show X/Y, you will see your XY info. on column/row headers.
You can see that in the Direct Conversion dialog, depending on how your data is organized in workbook, you can choose Y across columns, or even no X, Y in workbook.
Thanks, Snow Li
OriginLab Corp.
|
 |
|
|
nikhilts
USA
Posts |
Posted - 02/11/2008 : 6:22:12 PM
|
Hi! Snow Li,
Thanks for the detailed procedure. Everything worked fine in creating the matrix. But after creation of the matrix, Choose View: Show X/Y is not showing the appropriate X data and Y data values. The matrix only shows z data values.
Moreover when I tried to plot the 3D surface the X and Y data ranges did not show up appropriately. My X and Y data ranges are 1-2 and 0-3 respectively but both of them showed up to be 2-20.
All the settings were the same as u described in your post.
Am I missing something in between the procedure? Looking forward for help.
Thanks in advance.
-Nikhil
|
|
|
|
snowli
USA
1426 Posts |
Posted - 02/12/2008 : 08:56:14 AM
|
Hi Nikhil,
1. Sorry that I forgot to ask if you X and Y are evenly spaced or not. Also in your case below, i suppose your Z data is organized by x across columns/y across rows.
If it's not evenly spaced, then it will not work well. The direct conversion will make X and Y data evenly spaced, which may not be what you want. You may need to organize your data into
X column, Y column, Z column and then use XYZ Gridding.
2. In the Matrix, by default row number and column number show (1,2,3,4, ....) in col header and row header areas. If you choose View: Show X/Y, X, Y values will show there.
Actually no matter in View: Show X/Y mode or View: Show Column/Row, it should plot correctly.
3. If it still doesn't work, you can email your data/opj to tech@originlab.com if you want. I can work on it.
Thanks, Snow Li
OriginLab Corp.
|
|
|
|
nikhilts
USA
Posts |
Posted - 02/12/2008 : 11:26:33 AM
|
Hi! Snow Li,
Thank you for the clarifications on direct conversion into matrix.
Now that my data is not evenly spaced I am trying the XYZ-gridding by placing the X,Y and Z data in columns.
X-data: 1x20 array ---- stored in column A
Y-data: 1x20 array ---- stored in column B
Z-data: 20x20 array ---- stored in columns C through V
But as I explained in my first post...
1) I opened Worksheet: Convert to matrix: XYZ gridding: open dialog.
In the Input data section of this dialog box, I tried to select multiple columns of my 20x20 Z-matrix but it accepts only the first column of data. It only shows [Book1]Sheet1!C[1:20].
Can you please tell me how to make it consider the whole 20x20 matrix for Z-data.
Thank you.
-Nikhil
|
|
|
|
easwar
USA
1965 Posts |
Posted - 02/12/2008 : 12:09:20 PM
|
Hi Nikhil,
Your data configuration indicates that for each pair of X,Y values you have 20 different Z values. If this is correct, you may want to simply average all the 20 Z columns to create single averaged Z value column and then use that average Z value with your X and Y to do the gridding.
If on the other hand the 20 columns of Z values are not repeat measurements for every X,Y pair, then you have to reorganize your data (by writing script or manually) to convert it to three columns representing X, Y and Z and then do the gridding.
Easwar
OriginLab
|
|
|
| |
Topic |
|
|
|
Matrix creation for 3D surface plotting