Subscribe

UiPath Activities

The UiPath Activities Guide

Insert Excel Chart

UiPath.Excel.Activities.Business.InsertExcelChartX

Inserts a chart in a sheet at the specified location. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

You can choose from the following chart categories and their chart types:

Chart category

Chart Type

Area

Area
Stacked Area
100% Stacked Area

Bar

Clustered Bar
Stacked Bar
100% Stacked Bar

Column

Clustered Column
Stacked Column
100% Stacked Column

Line

Line
Line with Markers
Stacked Line with Markers
100% Stacked Line with Markers
Stacked Line
100% Stacked Line

Pie

Pie
Doughnut

Scatter

Scatter with Smooth Lines
Scatter with Smooth Lines and Markers
Scatter with Straight Lines
Scatter with Straight Lines and Markers
Scatter

Configuring the Activity

In the Body of the Activity

  • Chart category - Click the drop-down menu to select the category of the chart to be created.
  • Chart type - Click the drop-down menu to select the chart type to be created based on the category that was selected.
  • Data Range - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the file and then a sheet, table, or range where to insert the chart, or select Indicate in Excel to indicate a range directly from the file. Alternatively, you can select Custom Input to enter a range, table name, or sheet name manually, or Open in Advanced Editor to enter a VB expression.
  • Inert into sheet - Click Plus plus buttonplus button on the right side of the field, then, from the menu, select the file and then a sheet, or select Indicate in Excel to indicate a sheet directly from the file. Alternatively, you can select Custom Input to enter a sheet name manually, or Open in Advanced Editor to enter a VB expression.
  • Inserted chart - Saves the chart for use in other activities. Click Plus plus buttonplus button on the right side of the field, then, from the menu, select Indicate in Excel to indicate where to save the chart. Alternatively, you can select:
    • Custom Input to enter a sheet and chart name manually.
    • Save for Later Use to save the value for later use in the automation.
    • Open in Advanced Editor to enter a VB expression.

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.

Output

Updated 3 months ago


Insert 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.