Choose New Calculated Column from the Data menu to create a new column of data for further analysis. This column can be mathematically related to another column or columns. The following tabs are available for editing the new column.
The following tabs are available on the New Calculated Column dialog:
Use the Column Definition tab to define the new column.
Use the Options tab to set up how the column is displayed on the graph.
Note: If you have multiple data sets in your table, the new calculated column will be added to all data sets unless you have a column or cell selected in one data set. If a column or cell is selected, the new column will be added to only that data set.