Skip to main content

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

  • Save chart to - Saves the chart for use in other activities. Click Plus 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.

Properties panel​

Common

  • DisplayName - The name displayed for the activity in the Designer panel

Input

  • Chart category - See Chart category in the body of the activity.
  • Chart height - Specify the height of the chart.
  • Chart left - Coordinates of how far to the right of the sheet the new chart will be inserted.
  • Chart top - Coordinates of how far from the top of the sheet the chart will be inserted.
  • Chart type - See Chart type in the body of the activity.
  • Chart width - Specify the width of the chart.
  • Data range - See Data range in the body of the activity.
  • Insert into sheet - See Insert into sheet in the body of the activity.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

  • Save chart to - See the options in the body of the activity.