2.2.3.15 insertGraph
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;
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.
Related X-Functions
insertImg, insertNotes, insertSparklines, insertArrow, insertVar
|