# Update Chart Workbook

> Update Chart Workbook activity that updates the properties of an existing chart in an Excel file.

`UiPath.Excel.Activities.UpdateChart`

## Description

Updates the properties of an existing chart in an Excel file. This is the cross-platform equivalent of the [Update Excel Chart](https://docs.uipath.com/activities/other/latest/productivity/update-chart-x) Windows-only activity.

:::note
The supported Workbook formats are `.xls`, `.xlsm`, `.xltm`, `.xlsx`, and `.xltx`.
:::

## Project compatibility

Windows | Cross-platform

## Properties and configuration

* **File** - The full path of the resource workbook. To switch to a local path, select the plus icon, and then **Use Local File**. The current field changes to **File (local path)**, where you can provide the full path of the workbook.
* **Chart** - The chart to update. Select the file, sheet, and chart, or enter the chart name manually. You can also reference a chart saved by the [Insert Chart Workbook](https://docs.uipath.com/activities/other/latest/productivity/insert-chart-workbook) activity.
* **SheetName** - The name of the sheet containing the chart. If not set, the chart is searched for in all sheets.
* **Chart modifications** - Select **Open Collection Builder** to add one or more modifications to apply to the chart. To set the options dynamically, you can use a variable. Select the plus menu icon, and then **Use an Expression**. The following modification types are available:
    * `new ModifyChartTitleChartModification With {.ShowTitle = False, .Title = "myTitle"}`
    * `new ShowHideLegendChartModification With {.ShowLegend = False}`
    * `new ShowHideDataLabelsChartModification With {.ShowDataLabels = False}`
    * `new ChangeDataRangeChartModification With {.UseTableSource = False, .SheetName = "Sheet4", .Range = "A2:B2"}`
    * `new UpdateAxisTitleChartModification With {.Axis = AxisOrientationType.Vertical, .ShowTitle = True, .Title = "myVertTitle"}`
    * `new UpdateAxisBoundsChartModification With {.Axis = AxisOrientationType.Vertical, .MinBound = 10, .MaxBound = 40}`

### Use Workbook

* **Workbook** - The existing workbook to use.

### Options

* **Password** - The password of the workbook, if necessary.