2.5.9 g2w

1 Brief Information
2 Command Line Usage
3 X-Function Execution Options
4 Variables
5 Description
6 Related X-Functions

Brief Information

Move graphs to worksheet cells in an mxn arrangement

Command Line Usage

1. g2w option:=recursive;

2. g2w option:= recursive cols:=4;

3. g2w embed:=link;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Output Worksheet	ow	Output Worksheet	<new>	Specifies the worksheet which the graphs will be moved into. See the syntax here.
Move Graphs From	option	Input int	folder	Specifies the graphs to be moved. Option list page:Active Page Moves all graphs in the active page into the target worksheet. folder:All in Active Folder Moves all graphs in the active folder, not including those in its subfolders, into the target worksheet. recursive:All in Active Folder (Recursive) Moves all graphs in the active folder, including those in the subfolders, into the target worksheet. open:All in Active Folder (Open) Moves all open graphs in the active folder into the target worksheet. All hidden graphs are excluded. embed:All in Active Folder (Include Embedded) Moves all open graphs in the active folder, including those that are embedded in worksheets, into the target worksheet. Note: this option is only available when the Embed variable is set to Linking. project:All in Project Moves all graphs in the project. specified:Specified Moves the specified graphs into the target worksheet. The Graphs box will be enabled.
Graphs	graphs	Input string		If the Move Graphs From variable is set to Specified, user can use this text box to enter the names of the graphs to be moved. In this case, the browse button to the right of this text box becomes enabled and you can use it to browse for the graphs to be moved. However, if other options are selected for the Move Graphs From variable, this textbox will be read-only. You can see the names of the graphs that will be moved, but you cannot edit the content of this text box.
Graph Arrangement	arrange	Input int	nm	Specifies how to arrange the graphs and their names Option list Vertical:Vertically Two columns in the target worksheet will be used. The name so the graphs will be put in the first column. And the graphs will be put in the second column. nm:NM Panel* N columns in the target worksheet will be used, where N is specified by the cols variable. The name of the graph will be put in the cell above the cell where the graph is embedded.
Columns(N)	cols	Input double	3	This variable is available only when the arrange variable is set to NMPanel. It specifies the number of columns that will be used to arrange the graphs.
Embed	embed	Input int	embed	Specifies whether or not to embed the graphs. If the graphs are not embedded, they will be linking to the worksheet instead. Option list Embed:Embedding Embeds the graphs into the target workbook. Link:Linking Link the graphs to the target workbook.

Description

This function moves the selected graphs into a worksheet. You can use it to arrange graphs.

Graphs can be either embedded into the workbook or linked it. When a graph is embedded, it cannot be seen in the Project Explorer. However, you can open it again by double-clicking on the cell where it is embedded into. When a graph is linked, it will not be moved into the cell. However, you can see a miniature of it there. If you double-click on the cell, the linked graph will be active.