Contents |
Insert Graph
Insert a graph into a worksheet cell
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;
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Graphs | gname |
Input string | | ' character. |
| Move Graph to cell (Embedding) | embed |
Input int | | 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 | | Specify the method of display caching.
Option list:
|
| Resize Cell | resizecell |
Input int | | Specifies whether or not to resize the worksheet cell to fit the embedded or linked graph. |
| Keep Aspect Ratio | keepAspect |
Input int | | Specifies whether or not to keep the aspect ratio of the graph. |
| Hide Axes and Legend | axes |
Input int | | 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 | | 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 | | 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. |
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.
insertImg, insertNotes, insertSparklines, insertArrow, insertVar