15.5.1 Custom Table Style Template and Quantities in Table
When fitting from a graph window, you can decide whether or not to paste result tables to the source graph as well as customize the table format by specifying a worksheet template in Table Style Template, or customize the table content by dialog or specifying a .INI file in Quantities in Table.
Table Style Template
The report table is created by a built-in workbook template. Similar to manipulating a regular worksheet, you can customize the worksheet styles like fonts, background color, etc, and save this worksheet as a template, and then specify this template on Template to Create Table edit box.
- Import the file \Samples\Curve Fitting\Linear Fit.dat, highlight column B and plot a scatter plot.
- With the graph page active, select Analysis: Fitting: Linear Fit to bring up the Linear Fit dialog. Accept the default settings and click the OK button. The result table is pasted on source graph.
- Double-click the table to open it in a worksheet window. Set the first row's background color to red.
- Select File: Save Template As from the Origin menu. Name it as MyTemplate, and save it.
- Go back to the raw data worksheet. Highlight column C and create a scatter plot.
- With the graph active, bring up the Linear Fit dialog again. On Output tab, Expand Graph: Show Result Table to Source Graph branch, enter "MyTemplate" in the Table Style Template edit box.
- Click the OK button to fit. You can see the first row of report table in the result graph is red. In other words, the user-defined template was used to create the table on the graph.
Quantities in Table
Two methods are provided to control the items shown in Table in the graph:
- Using Quantities in Table dialog
- Editing *.ini file. When using this methods, enter the ini file name into the Quantities in Table box.
To revert the new report table (Results ± Errors together) to old report table (Results and Errors in two columns), simply delete all entries in the Quantities in Table dialog and press OK. See this FAQ for more information.
Quantities in Table dialog
This dialog can be opened by clicking the button beside the Quantities in table, it can be used to add or delete the quantities to put in the graph table by selecting from the fly out list menu at right, it also allows to adjust the order of quantities, delete quantities, or select by clickingbutton. Then after clicking OK, it will produce a notation string to the edit box to indicate the content of the table.
The following tutorial introduces the steps of creating linear regression report table on graph.
- Start with a new workbook and import the file \Samples\Curve Fitting\Linear Fit.dat.
- Click and select the second column and use the menu item Plot: Symbol: Scatter to create a scatter plot.
- With the graph active, use the menu item Analysis: Fitting: Linear Fit... to bring up the Linear Fit dialog.
- On the Fit Control tab, clear the Apparent Fit check box.
- On the Output tab in the dialog, expand Graph-> Show Result Table to Source Graph node. Click the button next to the Quantities in Table to open the Quantities in Table dialog. Click CTRL and click to select the Equation, Plot, Weight, Residual Sum of Square, R-Square(COD) in the list, click to remove, the left items will be shown in the graph, click OK to apply.
- Click OK to close the Linear Fit dialog, the result graph will be similar to graph below:
Custom Quantities in Table by editing INI file
Origin uses themes, which save as .INI files in \CustomTable folder, to specify the table content. If you want to create a new theme, you should make a new .INI file, save in the \CustomTable folder and specify this .INI file on Quantities in Table edit box.
How to indicate a report tree value
The content in report tables is just links to the report worksheet, and the report worksheets are organized by tree structure, so you can just specify the tree nodes on the .INI file by:
For example, the following curve slope value can be written as:
Note that the node names are some what different from what you see in report worksheet, please refer to the following node item names.
Node item names
Notes table (Notes)
Input Data table (Input)
(Where n is the nth column / row)
Parameters table (Parameters)
Statistics table (RegStats)
Number of Points
Degrees of Freedom
Residual Sum of Squares
Number of Iterations
Summary table (Summary)
ANOVA table (ANOVAs)
Sum of Squares
(Notes: N means the nth ANOVA table)
Constructing INI file
- The theme files have a look of standard .INI files: there are sections that start with
- line, followed by
- entry pairs. For now only one section, with the name [DataLinks], is supported. Lines start with semicolon ";" are comment lines.
- All entries should have names that start with the prefix "Entry", followed by a number. The numbers are used to order the entries in the theme vertically. Note that one entry, when theme is applied to a custom table, may result in more than one row. So, for example, if there are two entries, Enrty1 and Entry2, and Entry1 produced 3 rows in the custom table, then the Entry2 in the custom table will appear starting with row 4.
- Each entry value can consist of zero or more items, separated by space. The items will appear from left to right (i.e. in subsequent columns) when the theme is applied to a custom table. If an entry is empty (i.e. it has zero items) it results in an empty row when the theme is applied.
- Each item can consist of several parts. The parts can be either the node names of a report tree that refer to some other tables, in which case they produce links to other tables, or they can be literal strings which will be put as such in cells when the theme is applied. If there is space in the items, they ought to be quoted.
- If an item is a link, it typically looks like this:
- Every link item must begin with the name of a node in the report tree that represents a table. RowNodeName represents the name of a node that produces one row in the TableName table (that it represents a row is indicated by the fact that the node name is in square brackets). ColumnNodeName represents the name of a column node in the TableName table. The above link will, when applied as a theme to a custom table, produce the link to one cell: the cell is in the table TableName, in the row RowNodeName, and in the column ColumnNodeName. For example:
- is a link to the Value of the first parameter in the Parameters table.
- Several column nodes of the same table can be combined in one link. For example:
- will produce two cells side-by-side: the links to the Value and the Error cells of the first parameter in the Parameters table.
- If a row or a column node name is omitted, the result is a link to the "whole" other dimension. For example
- produces the link to the whole Value column, and
- produces a link to the whole row of the first parameter in the Parameters table.
- If both row and column node names are omitted, and only the table node name (followed by '!') is present, the result is a link to the whole table. Such as:
- is a link to the whole Parameters table.
- There is a special keyword -- Labels. It is used to indicate that in the given dimension the link to labels should be produced. For example:
- produces the columns labels of the table RegStats. And
Open the file \CustomTable\FitNL.INI by notepad, you can see the default output table theme for nonlinear curve fitting is (valid lines):
which represent the following tables on report worksheet:
To involve the p value in ANOVA table to the graph table, just modify the file to:
Entry3="Model P Value" ANOVAs!PValue[Regression1]
Create a folder named CustomTable in you User File Folder. Origin will use settings (.INI file) in User File Folder first. Then save the .INI file, say MyTheme.INI in the new created CustomTable folder. To use this theme, specify the file (full name) on Output: Settings: Show Result Tables to Source Graph: Quantities in Table edit box.