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

Last Update: 9/10/2019


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.

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