It is common to see three-dimensional spreadsheet data arrayed with X coordinates in the first row and Y coordinates in the first column (or vice versa):
If the X and or Y spacing is non-linear (as shown above) then normal gridding methods cannot create a matrix.
To work with this data in Origin, you can convert it to a Virtual Matrix using an X-Function (w2vm) or you can rearrange it into an XYZ column format using a menu option.
To use the menu option:
This opens the w2xyz dialog box. This dialog box uses the w2xyz X-Function.
In the Conversion Options branch of this dialog box, you can specify how the original data are arrayed: X across columns, Y across columns, or No X and Y (meaning the X and Y coordinate values are not supplied and Origin should use column and row indices). If supplied, the X and Y coordinates do not have to be evenly spaced.
Controls recalculation of results
For more information, see: Recalculating Analysis Results
The data input range.
For help with range controls, see: Specifying Your Input Data
The format of the source data:
Location of X values. Available when Data Format = X across columns.
Location of Y values. Available when Data Format = Y across columns.
Only available when X Values in or Y Values in = Column Label. Choose the label row to supply the X or Y coordinates.
Look for X values in first column. Available when Data Format = Y across columns.
Look for Y values in first column. Available when Data Format = X across columns.
Trim empty rows and columns from the worksheet.
Specify three columns for the output XYZ range. X, Y and Z data can be output to different sheets and books.
For help with the range controls, see: Output Results