Option
|
Description
|
---|---|
Deletes a row or a column
|
|
Moves the column to the right
|
|
Moves the column to the left
|
|
Moves the row down
|
|
Moves the row up
|
|
Add Row
|
Adds a row to the matrix. The row is added below the other rows.
|
Add Column
|
Adds a column to the matrix. The column is added to the right of the other columns.
|
Data range in rows from
|
Determines which rows to use when the table or chart is displayed
|
Data range in columns from
|
Determines which columns to use when the table or chart is displayed
|
Display as
|
Changes the way the values in the matrix are displayed. Choose from the following display options:
▪ Table
▪ Table Without Headings
▪ Line Chart, Bar Chart, or Column Chart: Graphical representations of the values in the matrix. The charts can be displayed only if the cells contain numerical values: either plain numbers, or results from numerical expressions.
Line charts are displayed properly only if your data range meets the following requirements:
▪ At least two columns and at least two rows.
▪ One row and at least two columns when Flip matrix axes is not selected.
▪ One column and at least two rows when Flip matrix axes is selected.
Note In a matrix, when you enter numbers, use only the period sign (.) as the separator for decimal values.
|
Flip matrix axes
|
Displays he matrix columns are displayed as rows, and the rows as columns in the attribute list.
|