2.2.3.16 insertGraph

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

Menu Information

Right-click context menu of worksheet cell: Insert Graph

Brief Information

Insert graph into a worksheet cell

Command Line Usage

1. insertGraph gname:=graph1;

2. insertGraph gname:=graph1 keepaspect:=0 resizecell:=0;

3. insertGraph gname:=graph3 embed:=1 keepaspect:=1 axes:=1 label:=1;

4. insertGraph gname:=graph1|graph2 embed:=0 keepAspect:=0;

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
Graphs	gname	Input string	<unassigned>	' character.
Move Graph to cell (Embedding)	embed	Input int	1	Specifies whether or not to embed the graph into the worksheet cell. If this checkbox is cleared, the graph will be linked to the graph. Otherwise, the graph will be embedded into the cell.
Display Caching	display	Input int	0	Specify the method of display caching. Option list: emf:Enhanced Metafile Display the inserted graph in EMF format. bmp:Bitmap Display the inserted graph in BMP format.
Resize Cell	resizecell	Input int	0	Specifies whether or not to resize the worksheet cell to fit the embedded or linked graph.
Keep Aspect Ratio	keepAspect	Input int	1	Specifies whether or not to keep the aspect ratio of the graph.
Hide Axes and Legend	axes	Input int	0	Specifies whether or not to hide the axes of the graph when it is displayed in the worksheet cell.
Hide Text Labels	label	Input int	0	Specifies whether or not to hide the text labels on the graph when it is displayed in the worksheet cell.
Top Left Cell	cell	Output Range	<active>	Specifies the top left cell where the first graph will be inserted. Other graphs, if any, will be inserted in cells to the right then below.

Description

This X-Function inserts the chosen graph(s) into specified cell in a worksheet.

Inserted graphs can be either embedded or linked. When a graph is embedded, it is moved into the worksheet cell. You can open the graph again by double-clicking on the cell. When an open, embedded graph is closed, there is no prompt to Hide or Delete since the graph still exists as an embedded graph. When a graph is linked, it will not be moved into the cell. However, you can double-click the image of the graph in the cell, and the source graph window and the folder in which it resides will become active.