8.15.2 The Merge Graph Dialog Box

You can open the Merge Graph Windows Dialog Box from the menu Graph: Merge Graph Windows, when a graph is active.

Merge Graph Dialog Box1.png

This function merges the specified graphs into a new graph window. In the new graph, the source graphs are arranged in row by col grid.

Graphs

Lists graphs in the order in which they are to be merged. Buttons at the top of the box allow for selecting and sorting of graphs. Note the flyout menu for graph selection.

Merge Graph Dialog Box Graphs Controls.png

Flyout Menu Options

Active Page All graphs in the active page.
All in Active Folder All graphs in the active folder, excluding those in the subfolders.
All in Active Folder (Recursive) All graphs in the active folder, including those in the subfolders.
All in Active Folder (Open) All open graphs in the active folder.
All in Active Folder (Include Embedded) All graphs in the active folder, including the embedded graphs.
All in Project All graphs in the current project.
... Opens the Graph Browser (see next section).

Graph Browser

The Graph Browser is used for adding graphs to the Graphs list. Using the folder filter drop-down in the upper-left corner, you can browse all graphs in the folder and then, using the Button Expand Panel Right.png and Button Expand Panel Left.png buttons, add or remove graphs from the Graphs list.

Merge Graph Dialog Box Browser.png


A couple of things to note:

  • By checking the Show Embedded Graph box, you can browse and include graphs that have been embedded in worksheets (and may no longer exist as standalone graphs).
  • You can sort or rearrange graphs in the right-hand panel by (a) clicking on the Name heading or (b) by dragging the button that is just to the left of the graph Name.

Keep Source Graphs

Specifies whether or not to keep the source graphs after the merging is performed.

Rearrange Layout

Specifies whether to rearrange the layers that belong to graphs that include multiple layers.

Note that when merging multi-layer graphs that have linked layers, each graph will be treated as a unit thus preserving layer linking relationships within individual graphs.

Merge linked layer graphs.png

Arrange Settings

Settings to arrange layers:

Number of Rows Specifies the number of rows in the new graph. The graphs will be arranged on a row by col grid in the new window.
Number of Columns Specifies the number of columns in the new graph. The graphs will be arranged on a row by col grid in the new window.
Add Extra Layer(s) for Grid Specifies whether to add new layers for empty grids, when the number source graphs is less than the product of the values of the row variable and the col variable.
Keep Layer Aspect Ratio Specifies whether to keep the original aspect ratio of the graph layers.
Treat Each Source Graph As a Unit When this box is checked, all layers from the same source graph are treated as a unit when merging graphs. Unlinked layers in the source graph will be linked to the original Layer1.
Link Source Graphs Link all unlinked layers to Layer1 in the merged graph. Linked layers remain linked to the layer they were linked to before merging.

Note: Checking both Treat Each Source Graph As a Unit and Link Source Graph causes:

  • Unlinked layers in each source graph to be linked to Layer1 of the source graph.
  • Layer1 of each source graph to be linked to the Layer1 of the merged graph.
Set Layer Width by Common Scale

The width of each layer is determined using a common scale. For instance, when drawing stacked bar charts, establishing a common scale allows direct visual comparison of bar length across layers. By contrast, when this option is not enabled, two axes with the same physical dimensions may display very different scale ranges.

Set Layer Height by Common Scale

The height of each layer is determined using a common scale. For instance, when drawing stacked column charts, establishing a common scale allows direct visual comparison of column height across layers. By contrast, when this option is not enabled, two axes with the same physical dimensions may display very different scale ranges.

Show Axes Frame This checkbox specifies whether to show axes frame and hide axes/ticks of graphs when axes/ticks are overlapping.

Spacing (in % of Page Dimension)

Horizontal Gap Specifies the horizontal gap between adjacent layers.
Vertical Gap Specifies the vertical gap between adjacent layers.
Left Margin Specifies the left margin to the new graph page.
Right Margin Specifies the right margin to the new graph page.
Top Margin Specifies the top margin to the new graph page.
Bottom Margin Specifies the bottom margin to the new graph page.

Page Setup

Orientation Specifies the orientation for the new graph page, inclucing:
  • Landscape
  • Portrait
Width Specifies the width of the new graph page.
Height Specifies the height of the new graph page.
Unit Specifies the unit for the new graph page.

Scale Elements

Scale Mode Specifies how the axes, axes labels, legend, data plots, and other objects that are attached to the Layer Frame or Layer and Scales are affected when a layer in the new graph page is resized.
  • Auto: Uses the settings in the source graphs.
  • Scale with Layer Frame: Scales the layer elements proportionally with the layer.
  • Fixed Factor: Determines the size of the layer elements relative to their original size (font size, symbol size, and line width, etc.). The size of these elements is determined by multiplying their original size by the scale factor specified in the Fixed Factor edit box.
Fixed Factor This variable is available only when the Scale drop-down is set to Fixed Factor. It specifies the fixed scale factor.

Add Label

Label Text Controls for adding and formatting labels to merged graphs.
  • None: Labels are not added to graphs.
  • A: The Labels are shown in upper case (A, B, C...)
  • a: The Labels are shown in lower case (a, b, c...)
  • Custom: Define the label in the text box below.
Custom This text box displays when Custom is selected in the Label Text drop-down list. Specify the custom label texts.
  • When you select a$ and A$, the lowercase and uppercase letters will be enumerated to label the merged layers, such as (a, b, c...) and (A, B, C...).
  • When you select r$ and R$, the lowercase and uppercase Roman numerals will be enumerated to label the merged layers, such as (i, ii,iii...) and (I, II, III...).
  • When you select n$, the layer index will be enumerated to label the layers, such as (1, 2, 3...).
  • When you select h$, the character # will be added into the layers.
  • When you select Graph ## in the Custom text box. Labels in the form Graph 01, Graph 02, Graph 03, etc., will be added to the graphs.
  • The string register %H stores the name of the active window title. Choose this option to label with the window Short Name. Note that this is label is a static label. If the source window title is changed, the text label is not updated.

The Enable Substitution check box is selected by default, substitution notation and enumeration code are supported. For enumeration code, %(u$) and %(v$) enumerate uppercase and lowercase letters. $(i) and # enumerate index. %(p$) represents character #.

Label Position Controls label position. Labels can be displayed at Top Left Outside, Top Left Inside, Top Right Outside, Top Right Inside, Top Center Inside, Top Center Outside, or Bottom Center Outside.