Insert Excel Chart
- Updated2023-02-17
- 4 minute(s) read
Insert Excel Chart
Inserts a Scatter with Straight Lines chart to a worksheet of the Excel report. You can add several curves to the default chart by referencing further data columns in x columns or y columns. To display data in other chart types, create your own Excel template and connect it to template of the New Excel Report VI.
sheet
Name of the Excel worksheet that displays the chart.
report in
Reference to the incoming report.
x columns
X values of an Excel chart. To reference data for a chart, enter the column name. For example, use MyXData to display the data of the column MyXData in a chart.
y columns
Y values of an Excel chart. To reference data for a chart, enter the column name. For example, use MyYData to display the data of the column MyYData in a chart.
error in
Error conditions that occur before this node runs.
The node responds to this input according to standard error behavior.
Standard Error Behavior
Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.
| error in does not contain an error | error in contains an error |
|---|---|
| If no error occurred before the node runs, the node begins execution normally.
If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out. | If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out. |
Default: No error
range
Position of the chart on the Excel worksheet. Enter the values for the row and the column at the top left and the bottom right corner to determine the position of the chart.
top left
Top left position of the Excel chart.
row
Excel row number for chart position.
column
Excel column number for chart position.
bottom right
Bottom right position of the Excel chart.
row
Excel row number for chart position.
column
Excel column number for chart position.
report out
Reference to the outgoing report.
error out
Error information.
The node produces this output according to standard error behavior.
Standard Error Behavior
Many nodes provide an error in input and an error out output so that the node can respond to and communicate errors that occur while code is running. The value of error in specifies whether an error occurred before the node runs. Most nodes respond to values of error in in a standard, predictable way.
| error in does not contain an error | error in contains an error |
|---|---|
| If no error occurred before the node runs, the node begins execution normally.
If no error occurs while the node runs, it returns no error. If an error does occur while the node runs, it returns that error information as error out. | If an error occurred before the node runs, the node does not execute. Instead, it returns the error in value as error out. |