# Update Excel Chart

> `UiPath.Excel.Activities.Business.UpdateChartX`

`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](https://docs.uipath.com/activities/other/latest/productivity/excel-application-card) activity or with the Project Notebook.

## Configuring the activity

#### In the body of the activity

* **Chart** - Select **Plus** 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](https://docs.uipath.com/activities/other/latest/productivity/insert-excel-chart-x) 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** - Select **Plus** 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** - Select **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". Select **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". Select **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.

## Related activities

* [Update Chart Workbook](https://docs.uipath.com/activities/other/latest/productivity/update-chart-workbook) — The cross-platform equivalent of the **Update Excel Chart** activity.