The Table Menu

This menu is only active when a table is selected.

Set Column As

These commands are used to define the kind of data which is stored in the different columns of a table.

Set Column As -> X

Define the selected column as abscissae for the plots. You can define more than one column as X-values in a tables, they will be referenced as X1, X2, etc.

Set Column As -> Y

In the case of 2D plots, this command defines the selected column as Y-values for the plots. In the case of 3D plots, Y columns can be used as the second abscissae.

Set Column As -> Z

In the case of 3D plots, Z columns will be used as plotted values.

Set Column As -> X error

Define the selected column for use as error bars width for abscissae.

Set Column As -> Y error

Define the selected column for use as error bars for Y-values.

Set Column As -> None

The selected column can be used in different ways in several plots (as X values, Y values, etc).

Column Options...

This command is used to define the global parameters of each column such as numeric format, column name, etc. See the corresponding dialog box section for more details.

Set Column Values...

This command is used to fill the selected column with the values resulting from a mathematical formula. See the corresponding dialog box section for more details.

Recalculate

When you fill a column (named for example 'C1') with the results of a formula (by using the Set Column Values... command), the values of the column are calculated only once when you define the formula. If your formula depends on values of another column (name for example 'C2'), the values of 'C1' are not updated if you modify the values in 'C2'. This command is used to recalculate the values of the selected column.

Fill column with

This command is used to fill the selected column with special values:

Fill Column With -> Row Numbers

The filling is done with the number of the corresponding rows.

Fill Column With -> Random Numbers

The filling is done with random values between 0 and 1.

Clear

Removes all the values of the selected column

Add Column

Adds a new column in the table. Whatever the selected column, the new one will be inserted at the right of the table after the left column.

Columns

Allows to define the number of columns in the table. Be carefull if you decrease the number of columns in a table, a number of columns will be removed and the data will be lost.

Rows

Allows to define the number of rows in the table. Be carefull if you decrease the number of rows in a table, a number of rows will be removed and the data will be lost.

Go to Row...

Defines the active line in the selected table.

Convert to Matrix

This command is used to convert a table into a matrix. It is mainly used to import data from files: the first step import data in a table, and the second one is the conversion of the table in a matrix.