8.3.5 Batch Plotting
Origin allows you to customize your graphs, then reuse the custom settings with similar data. You can save your custom settings either as templates or Themes. Alternately, you can use Origin's batch plotting or Change Worksheet feature. Unlike graph templates and Themes, batch plotting does not require pre-saving a file and it is especially useful when working with multi-column/sheet/book data.
In this section, we will discuss how to do batch plotting with new columns/sheets/books having an identical structure to the original column/sheet/book data.
Supported graph types
- Batch plotting is only available for 2D/3D/Contour graphs in the same project and of same data source type.
- When duplicating with new columns, each column should have a Plot Designation of Y(for 2D) or Z(for 3D or contour) and should be in the same sheet.
- When duplicating with new sheets, each sheet should have exactly the same column structure.
- When duplicating with new books, each book should have exactly the same sheet and column structure.
Duplicate with new columns
If the plot is from a Y/Z column in the worksheet, you can duplicate your plot using other Y/Z columns in this sheet. With the original plot active, right-click on the graph title bar and select Duplicate (Batch Plotting): Duplicate with New Columns.
A Select Column browser will open and list all columns in this sheet with the Y/Z column designation.
The Use Associated X or Use Associated X&Y box on bottom left is checked by default, and when selected, new plots will use the X column(s) associated with selected Y column(s). When this box is cleared, new plots will use the X / X&Y column(s) of the plot being duplicated.
The Graph Short Name and Graph Long Name edit boxes are used to define the duplicated graph names. Format strings can be entered, and multiple notations and arbitrary fixed strings can be combined as desired. The button to the right of the edit box provides some frequently used notations and example syntax. The default <auto> in the Graph Short Name edit box assigns the name Graphn to the new graph window. The default <auto> in the Graph Long Name edit box copies the source graph Long Name and appends the string "- Copy".
Note that for a 3D or Contour plot created from a matrix object, use the Duplicate with New Columns option means to batch plot with other matrix object(s) in the same matrix sheet.
Duplicate with new sheets/books
If all plots in a graph are from one sheet, you can launch the batch plotting feature to duplicate your graph using other sheets. With the original graph active, press the button on the Standard tool bar, or right click on the graph title bar and select Duplicate (Batch Plotting): Duplicate with New Sheets/Books.
- A Select Worksheet browser opens and all matching sheets in the project are listed according to the Matching Columns by filter.
- Choosing Long Name, Short Name or Column Index in this filter, you can implement batch plotting to designated worksheets that have the same Long Name, Short Name or Column Index structure as the original worksheets.
- The Graph Short Name and Graph Long Name edit boxes are used to define the duplicated graph names.
- Format strings/Labtalk scripts can be entered, and multiple notations and arbitrary fixed strings can be combined as desired. The button to the right of the edit box provides some frequently used notations and example syntax.
- The default <auto> in the Graph Short Name edit box means to set the duplicated graph Short Name as Graphn, where n is Graph window's sequence number.
- The default <auto> in the Graph Long Name edit box means to set Long Name as a combination of a fixed string "Duplicated with" and the source workbook and sheet name.
- The Match Plot Columns by list does NOT apply to modifiers (worksheet columns of values used to modify the plot - e.g. plot color). The template's Match Modifier(s) by setting is used instead. If you don't like the template's current Match Modifiers setting (viewable by right-clicking on the graph window's title bar and choosing Save Template As) and you don't want to resave the template, open Plot Details (File: Plot Properties), click the Miscellaneous tab and change the Match Modifiers by setting here.
When all plots in a graph are from one book, you can employ batch plotting to create a new graph for each book. In this instance, the Select Workbook browser will be opened (instead of the Select Sheet browser). By specifying the Matching Columns by filter, workbooks that meet the filter requirement would appear in the Select Workbook browser. Because batch plotting remembers dataset assignment from specific sheets, the generated graphs will have the same plot configuration as the original.
|Note: Change Worksheet is a feature that allows you to recreate an existing 2D graph using datasets in another sheet. Both Batch Plotting with New Sheets and Change Worksheet require sheets with the exact same column structure including short names, plots designations and indexes. Change Worksheet allows you to quickly change data plots within in a layer using a (right-click) shortcut menu command. Change Worksheet can be applied one-by-one to each plot within a multi-plot layer. This feature is available when plots are not "grouped". When plots are "grouped", click once, pause, then click a second time and this feature will become available (note that in this mode, you are still only replacing a single plot -- not the entire plot group).