Update Chart

This activity allows users to modify an existing chart by performing actions such as updating the data range, axis titles, axis bounds, chart title, and showing or hiding legends and data labels.

It functions as a scope activity for all chart-related modifications, and this activity must be placed inside the Excel Scope.

Properties

Input

Sheet Name: *Indicates to provide the “SheetName” to insert the data, and it accepts values in the “String” datatype.”

Chart Name: *Specifies to provide the “Chart name” generated and it accepts values in “String” datatype.

Add the modification from the below button:  Allows users to choose and add the modification action to be performed. Selecting the action will automatically include the child activity into the scope.

Modification Options

a. Update Chart Title: Updates the main title of the chart.
b. Update Axis Title: Modifies the title of the X-axis or Y-axis.
c. Update Axis Bounds: Adjusts the minimum and maximum values displayed on the chart axes.
d. Change Data Range: Updates the existing data range with a new one for the chart.
e. Show/Hide Legend: Displays or removes the chart legend.
f. Show/Hide Data Labels: Shows or hides data labels on the chart for better visualization.

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

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.