Update embedded graphs in worksheet
1. updateEmbedGraphs;
2. updateEmbedGraphs rng:=[Book1]Sheet1 keepaspect:=0;
3. updateEmbedGraphs rng:=[Book1]Sheet1!Col(2):Col(3) axes:=1 legends:=0 texts:=1; // hide axes, texts
Please refer to the page for additional option switches when accessing the x-function from script
| Display Name |
Variable Name |
I/O and Type |
Default Value |
Description |
|---|---|---|---|---|
| Graph Range | rng |
Input/Output Range |
|
The specified range embedded graph need to update. |
| Keep Aspect Ratio | keepaspect |
Input int |
|
Whether to keep aspect radio or not. |
| Hide Axes | axes |
Input int |
|
Whether to hide axes or not. |
| Hide Legends | legends |
Input int |
|
Whether to hide the legends or not. |
| Hide Texts | texts |
Input int |
|
Whether to hide texts or not. |
This function is used to update the embedded graphs in the worksheet. It can decide whether to keep the original aspect ratio keepaspect, whether to hide axes axes, whether to hide legends legends, and whether to hide texts texts.