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
  • 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 18 days 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.