OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                           
 

4.2.4 Adding Graph, Matrix or Notes Windows as Sheets


Sometimes you might need to add some graphs and matrix into current workbook, especially when create the Analysis Templates, then, you can right-click on the existing sheet tab to select Add Graph as Sheet or Add Matrix as Sheet item to add graph and matrix window into the workbook as new sheets.

Basic operations on WKS.png

Once you right-click on a sheet tab and select Add Graph as Sheet or Add Matrix as Sheet:

  • an empty graph/matrix window will be added as a new sheet if there is no graph/matrix window in current project.
  • the newly created graph/matrix window or the unique graph/matrix window in current folder will be added into current workbook as a new sheet if you just created a graph/matrix window in the past 40 second or there is only one graph/matrix window in current fodler. Please note, this time interval for newly-created graph/matrix can be modified by the system variable @MMT.
  • the Hunt dialog will pop up to let you select the desired graph/matrix window to insert into current workbook if you have not activated any graph/matrix window in past 40 second.
    Graph Matrix Hunt.png
    For the initialization for this Hunt dialog,
    • If the current folder has a recently modified window, it will be picked to initialize the dialog.
    • if no recently modified in current folder, the window active will be used to initialize the dialog. you can use the system variable @AGF=1 to change the target folder to look at.
    • if the last active window is not the proper type, or project was just open and not last active info, then dialog is not initialized.

    If the initially selected window in the Hunt dialog is not you desired, you can select another graph/matrix window by clicking on it. Then, click Done button to add it into the current workbook as a new sheet.

Graph as Sheet

If you use the context menu to add a graph as a new sheet, the short name of graph window will be used to name the new sheet and the graph will be inserted into a first cell of current sheet. Double-click on the embedded graph to open the graph window to customize it. Once the customization is done, click the Return button Analysis Report Sheets and Worksheet Columns-4.png to restore the graph.

Right-click on the embedded graph, you can
Add Graph as sheet 01.png

  • insert a blank cell above the cell the graph embedded into.
  • delete the embedded graph, but the containing cell will be kept in the new sheet.
  • switch the image caching between Enhanced Metafile and Bitmap
  • Restore the graph window, which means the original graph window will be re-activated and the sheet with embedded graph will be removed.
  • convert the embedded graph as a graph link, and convert the graph link back to an embedded graph.

Worksheet-embedded graphs can be merged and exported without double-clicking on the embedded objects to open them in separate windows. Both the Merge Graph and the Export Graph dialog boxes offer an All in Active Folder (Include Embedded) option, when selecting graphs to merge or export.

For more information, you may also want to see this post on the Origin Blog.

Matrix as Sheet

If you use the context menu to add a martix as a new sheet, the short name of matrix window will be used to name the new sheet, the matrix will be inserted into a first cell of current sheet and the current active object will be indicated in the title cell. Double-click on the embedded matrix to open the matrix window to perform operations. Once the manipulation is done, click the Return button Analysis Report Sheets and Worksheet Columns-4.png to restore the matrix.

Right-click on the embedded matrix, you can
Add Graph as sheet 02.png

  • insert a blank cell above the cell the matrix embedded into.
  • delete the embedded matrix.
  • restore the matrix window, which means the original matrix window will be re-activated and the sheet with embedded matrix will be removed.
  • navigate the the matrix sheet and then matrix objects. You can use this context menu to change the active object.

Notes as Sheet

You can also add a new Notes window as a sheet in the workbook (note that unlike graphs and matrices, you cannot add an existing Notes window as a sheet).

  1. Right-click the worksheet tab and choose Add Notes as Sheet.
  2. Double-click on the placeholder text to overwrite.

Embedding Graphs and Matrices in Analysis Templates

One logical application of worksheet-embedded graphs and matrices is to add supporting graphical information to an Analysis Template that is used to drive batch processing operations.

  • A graph that is added as part of an analysis operation -- a plot of data with a linear fit result, for instance -- can be automatically updated when new a new data file is imported into the template.
  • Analysis Templates support drag-and-drop import. When the Analysis Template includes embedded graphs, data files should be dropped onto the data sheet, not the embedded graph sheet.
  • You can drag-and-drop image files directly onto worksheet-embedded matrices and the image and any analysis-dependent operations will be updated.


For more information on Analysis Templates, see these topics:

 

© OriginLab Corporation. All rights reserved.