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                     
 

8.3.5 Batch Plotting


In Origin, there are several ways in which you can customize a graph, then reuse those customizations with other datasets.

To make use of graph templates and graph Themes, you must have previously saved a group of customizations to file. Copy/paste formats and batch plotting do not require pre-saving a file. All have their applications but batch plotting 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 or matched identifiers 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.

Three Cases of Batch Plotting

To open the Batch Plotting tool:

  • Right-click on the graph title bar or any blank area around the graph layer frame and select Duplicate (Batch Plotting).
Dialog Batch Plotting 01.png

You can use the drop-down list Batch Plot With to switch the different source data to duplicate the current graph:

Once you selected Book/Sheet/Column for the Batch Plot With option, the available books/sheets/columns will be list in the middle blank box respectively.

Duplicate with new books

If all plots in a graph are from one book, you can launch the batch plotting feature to duplicate your graph using other books, with the Batch Plot With drop-down list been set to Book. As you can see, the Batch Plotting dialog will show Select Workbook at the title bar to indicate current batch mode.

Dialog Batch Plotting.png
Settings for matching conditions
Matching Plot Columns/Sheet by Choosing Long Name, Short Name or Column Index in Match Plot Columns by filter, and Long Name, Short Name or Index in Match Sheet by filter, you can implement batch plotting to designated workbooks that have the same structure as the original workbooks.
Match Modofiers by This list is used to specify how to match the modifiers (worksheet columns of values used to modify the plot - e.g. plot color) when do batch plotting with the selected workbook(s). The default selection is associated with the Match Modifiers by control in the Miscellaneous tab of Plot Details dialog. Of course, you can do your own setting for current routine.
List the matching books

According to first part filter conditions, all matching books in the project are listed in the middle box. You can select one or multiple books' dataset to do batch plotting.

Settings for result graph
Rescale axes This box is checked by default. Clear the box to prevent rescale axes upon change of input data.
Rescale colormap if present This box is checked by default. Clear the box to prevent rescale colormap upon change of input data.
Plot Selected to This list is used to specify where the selected books will be plotted to. With this option, you can
1) plot the selected books to active graph
2) plot each selection to an individual graph respectively
3) plot the selected books to one new graph.
Graph Short Name This edit boxes is used to define the duplicated graph short names.
  • The default <auto> means to set the duplicated graph Short Name as Graphn, where n is Graph window's sequence number.
  • Format strings/Labtalk scripts can be entered, and multiple notations and arbitrary fixed strings can be combined as desired. The Triangle button 01.png button to the right of the edit box provides some frequently used notations and example syntax.
Graph Long Name This edit boxes is used to define the duplicated graph long names.
  • The default <auto> means to set Long Name as a combination of a fixed string "Duplicated with" and the source workbook and sheet name.
  • Format strings/Labtalk scripts can be entered, and multiple notations and arbitrary fixed strings can be combined as desired. The Triangle button 01.png button to the right of the edit box provides some frequently used notations and example syntax.


Duplicate with new sheets

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 Batch Plot With drop-down list been set to Sheet. As you can see, the Batch Plotting dialog will show Select Worksheet at the title bar to indicate current batch mode.

Dialog Batch Plotting Sheet.png
Settings for matching conditions
Matching Plot Columns 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.
Match Modofiers by This list is used to specify how to match the modifiers (worksheet columns of values used to modify the plot - e.g. plot color) when do batch plotting with the selected worksheet(s). The default selection is associated with the Match Modifiers by control in the Miscellaneous tab of Plot Details dialog. Of course, you can do your own setting for current routine.
List the matching sheets

According to first part matching conditions, all matching sheets in the project are listed in the middle box. You can select one or multiple sheets' dataset to do batch plotting.

Settings for result graph

The options are the same with the Settings for result graph in Duplicate with new books.

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).


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 Batch Plot With drop-down list been set to Column. As you can see, the Batch Plotting dialog will show Select Column at the title bar to indicate current batch mode.

Dialog Batch Plotting Column.png
Settings for matching conditions
Use Associated X / Use Associated X&Y This box 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.
Match Modofiers by This check box and its drop-down list are used to specify how to match the modifiers(the columns used to control the plot color or other plot attributes) when do batch plotting with the selected column(s). Here, the default selection follows the Match Modifiers by control in the Miscellaneous tab of Plot Details dialog.

Please note, for this kind of batch plotting, you are strongly recommended to select <Offset> for this option to pick the modifying column(s) with the same column offset starting from the selected plot column, since selecting any column label will always map the plot attributes to the first eligible columns in current worksheet.

List the matching sheets

According to first part matching conditions, all columns in this sheet with the Y/Z column designation are listed in the middle box. You can select one or multiple columns' dataset to do batch plotting.

Settings for result graph

The options are the same with the Settings for result graph in Duplicate with new books.

Note: 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.


You can see a small tutorial here to learn how this batch plotting tool works.

 

© OriginLab Corporation. All rights reserved.