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     
 
Skip Navigation Links
All BooksExpand All Books
Origin HelpExpand Origin Help
GraphingExpand Graphing
Basic GraphingExpand Basic Graphing

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 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 or any blank area around the graph layer frame and select Duplicate (Batch Plotting): Duplicate with New Columns.

Batch-column.png

A Select Column browser will open and list all columns in this sheet with the Y/Z column designation.

Select column bro.png

  • 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 Match Modifier 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.
  • 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 Triangle button 01.png 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.

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

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 original graph active, press the button Batch-but.png on the Standard tool bar, or right click on the graph title bar and select Duplicate (Batch Plotting): Duplicate with New Sheets/Books.

Batch-sheet1.png

A Select Worksheet browser opens and all matching sheets in the project are listed according to the Matching Plot Columns by filter.
Select sheet bro.png

  • Rescale axes and Rescale colormap... are checked by default. Clear the box to prevent rescale upon change of input data.
  • 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 Match Modofiers by 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.
  • 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 Triangle button 01.png 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.
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 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 original graph active, press the button Batch-book.png on the Standard tool bar, or right click on the graph title bar and select Duplicate (Batch Plotting): Duplicate with New Books.

Batch-book1.png

A Select Workbook browser opens and all matching books in the project are listed according to the Match Plot Columns by and Match Sheet by filter.
Batch-book2.png

  • Rescale axes and Rescale colormap... are checked by default. Clear the box to prevent rescale upon change of input data.
  • Matching Plot Columns/Sheet by filter: 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.
  • The Match Modofiers by 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.
  • 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 Triangle button 01.png 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.
 

© OriginLab Corporation. All rights reserved.