Insert Chart

This activity allows users to generate a chart in an Excel sheet based on the selected data range. It must be used within the “Excel Scope” activity.

Properties

INPUT

Chart Category*: Specifies the chart category to be generated. Available options include:

• Area

• Bar

• Column

• Line

• Pie

• Scatter

Chart Type*: Specifies the chart type within the selected category. Examples include:

• Stacked Bar

• Clustered Bar

• 100% Stacked Bar

Sheet Name*: Indicates the name of the sheet containing the data and accepts input value of String datatype.

Data Range*: Specifies the data range from the sheet that will be used to create the chart and accepts the input value of String datatype.

Insert Into Sheet*: Specifies the sheet where the generated chart should be inserted and accepts the input value of String datatype.

Chart Name: Specifies to provide the name for the chart being created and accepts the input value of String datatype.

Height: Specifies the height of the chart and accepts an Int32 value.

Width: Specifies the width of the chart and accepts an Int32 value.

Left: Indicates the starting column position in the sheet where the chart will be placed and it accepts values in Int32 datatype. Position starts from 0.

Right: Specifies the starting row position in the sheet where the chart will be placed and accepts values in Int32 datatype. Position starts from 0.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Inserted Chart Name: Returns the name of the chart created in String datatype.

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow