Activities
latest
false
Banner background image
Productivity Activities
Last updated 2024年3月27日

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 docs image 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 docs image 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 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 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 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.
Properties Panel

Common

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

Input

  • See the options in the body of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
  • Configuring the Activity

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.