Creating and Editing Columns

You can create a new column that is manually entered or based on calculations. The new column can calculate important results from other data in Graphical Analysis. For example, if you have current and voltage data, you can create a new column to calculate current times voltage, or power.

Creating a new column

1. Select New Manual Column or New Calculated Column from the Data menu, or click the corresponding buttons in the Data Browser.

2. Name the new column by editing the text in Name and Short Name text boxes.

4. Enter units in the Unit box. Choose a symbol, if needed, from the pull-down menu (Windows only. On Mac, use the Option key corresponding keystrokes for symbols).

5. If you are creating a new calculated column, enter your formula in the Equation text box. The definition can contain numbers, calculator functions (sin, sqrt, etc.), other columns, or functions such as smoothAve or derivative. You can either type the formula or select item(s) from the list of functions below to paste them in the definition box. Access the names of the other columns by scrolling down and choosing from the Variables (columns) menu. Access the additional constants by scrolling down and choosing from the Constants menu.

You can generate numbers for the manual column by checking the box next to Generate Column.

6. You can customize the column colors, assign point protectors, etc. from the Options tab, and assign the new column to a data set from the Data Sets tab.

7. Click the OK button when the information is complete.

Editing the properties of an existing column

Changing options for a single column

You can change options for a single column a few different ways. Any of these four will bring up the Column Options dialog box.

Right click in a table (Windows) or ctrl-click (Macintosh), select Column Options then choose the column you want to change. Here, the column's data set name will appear before the column's name
Double click on a column's name in a table
Choose Column Options from the Data Menu
Double-click on a column in the Data Browser

Changing options for multiple columns

You can change options for multiple columns as long as they share the same name.

1. In the Data Menu choose Column Options

2. Next, pick the column name you wish to make changes to.

Any changes you make will be made to ALL columns with the same name.