1.23 FAQ-136 How do I add and customize tables in a graph?

Last Update: 7/12/2022


The user can take several approaches:

Insert worksheet data:

  1. Select your worksheet cells, then right-click and Copy.
  2. Go to your graph, right-click and choose Paste, Paste Link (dynamically links table to results), or Paste Link Transpose (dynamically links table and transposes data).
  3. Copying and pasting a range of data does not allow simultaneous copying of column label row information. If you want to copy them, first double click the table to open the intermediate table. Turn on column label rows in the table and copy paste or paste link metadata from worksheet to table. Then click Update Table button.
Past link Table to Graph.gif

Insert a blank table and add data manually or copy/paste or paste link worksheet data:

  1. Choose Insert: Table menu. Alternatively, click the New Link Table button on the Graph toolbar.
  2. Specify number of columns and rows in the dialog that opens. Click OK.
  3. To add data, double-click on the table object. This opens a Table worksheet where you can input values and Update Table. Inputted values can link to cells containing results from fitting and other analysis report tables.

Insert Analysis Report Sheet Tables:

  1. Go to your Analysis Report Sheet, right-click on any report table heading (e.g. Notes, Statistics, Parameters, etc.) and choose Copy Table(Text) from the context menu.
  2. Go to your graph, right-click and choose Paste, Paste Link (dynamically links table to results), or Paste Link Transpose (dynamically links table and transposes data).
FAQ136 copy report tables.png

Note: You can also paste a range of data from report tables, although pasting limited ranges will not bring over header information.


See Also Insert Tables in Graph.

Add a report table of analysis results

Custom table theme Template04v.png

Most of Origin's analysis tools support adding a report table to plots of analysis results (e.g. the Linear Fit tool, Output tab). When adding a report table, the user can customize table content by opening the Quantities in Table dialog and adding, removing, or rearranging quantities. Style the table according to instructions in the next section.

Styling Tables

OH style table w MT.png
  • Alternately, you double-click on the table and open the table in a popup window. In the popup, use the Style and Format toolbars to style your table (some Mini Toolbar buttons will also be available depending on what is highlighted in the popup window). In addition, shortcut menus give you access to Format Cells, Set Data Styles and other useful functions. When you have made your changes in the popup, be sure to click the Update Table button to apply your changes and return to the graph or layout window.

Keywords:analysis, result, publish, grid, link, parameter, metadata