订阅

UiPath 活动

UiPath 活动指南

更新 Excel 图表

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.

配置活动

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.

2 个月前更新


更新 Excel 图表


建议的编辑仅限用于 API 参考页面

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