4.4.12 Converting Worksheet Data to XYZ

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):

W2xyz example source.png

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:

  1. Make your worksheet active.
  2. Click Worksheet: Convert to XYZ...

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.

Dialog Options

Recalculate

Controls recalculation of results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Worksheet

The data input range.

For help with range controls, see: Specifying Your Input Data

Data Format

The format of the source data:

  • X across columns
The X values are across columns.
  • Y across columns
The Y values are across columns.
  • No X and Y
There are no X or Y values in the worksheet. Column and row indices should be used for X and Y coordinates, respectively.
X Values in

Location of X values. Available when Data Format = X across columns.

  • None
There are no X values in the worksheet. Column indices are used as X values.
  • First Data Row
First data row supplies the X values.
  • Column Label
Column label row supplies the X values.
Y Values in

Location of Y values. Available when Data Format = Y across columns.

  • None
There are no Y values in the worksheet. Column indices are used as Y values.
  • First Data Row
The data row supplies Y values.
  • Column Label
Column label row supplies the Y values.
Column Label

Only available when X Values in or Y Values in = Column Label. Choose the label row to supply the X or Y coordinates.

X Values in First Column

Look for X values in first column. Available when Data Format = Y across columns.

Y Values in First Column

Look for Y values in first column. Available when Data Format = X across columns.

Trim Missing

Trim empty rows and columns from the worksheet.

Output

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