Subscribe

UiPath Activities

The UiPath Activities Guide

Update Excel Chart

UiPath.Excel.Activities.Business.UpdateChartX

Updates the properties of an existing Excel chart. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

  • Chart - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the file, sheet, and then a chart, or select Indicate in Excel to indicate a chart directly from the file. Alternatively, you select a saved chart created by the Insert Excel Chart activity, select Custom Input to enter a chart name manually, or Open in Advanced Editor to enter a VB expression.
  • Add Modification - Select an activity depending on what modification you want to make:
Change Data Range

Changes the data range of the chart:

  • Data Range - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the file, sheet, and then a range or table, or select Indicate in Excel to indicate a range or table directly from the file. Alternatively, you can select Custom Input to enter a range name manually, or Open in Advanced Editor to enter a VB expression.

Modify Chart Title

Changes the title of the chart:

  • Show title - Select Yes or No depending on whether you want the title of the chart to be displayed.
  • Title - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the text for the title using one of the available options:
    • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the text.
    • Use Saved Value - Select a value that you previously saved for later use in the project.
    • Paste from clipboard - Paste a value that you previously copied to the clipboard in the project..
    • Text - Enter the title using the Text Builder.
    • Ask when run - Prompt for the title when the project is executed.
    • Open in Advanced Editor - Enter a VB expression.

Update Axis Title
  • Axis - Indicates which axis to update.
  • Show axis title - Select whether to display the title of the axis or not.
Update Axis Bounds
  • Min bound - Updates the minimum bound of the chart's axis. Leave blank for "Auto". Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the a value using one of the available options:
    • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value.
    • Use Saved Value - Select a value that you previously saved for later use in the project.
    • Number - Enter a numeric value.
    • Ask when run - Prompt for the value when the project is executed.
    • Open in Advanced Editor - Enter a VB expression.
  • Max bound - Updates the maximum bound of the chart's axis. Leave blank for "Auto". Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the a value using one of the available options:
    • Data from the Project Notebook, a parent Excel file or Outlook account. For example, select an Excel file, and then select Indicate in Excel to indicate a cell from the file, or select an email in Outlook and then select a field in the email that contains the value.
    • Use Saved Value - Select a value that you previously saved for later use in the project.
    • Number - Enter a numeric value.
    • Ask when run - Prompt for the value when the project is executed.
    • Open in Advanced Editor - Enter a VB expression.
Show/Hide Legend
  • Show legend - If checked, the chart's legend is displayed. If unchecked, the legend will be hidden.
Show/Hide Data Labels
  • Show data labels - If checked, the data labels are displayed on the chart. If unchecked, the data labels will be hidden.

In the Properties Panel

Common

  • DisplayName - The name displayed for the activity in the Designer panel

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Updated 18 days ago


Update Excel Chart


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.