Skip to main content

Insert Chart Workbook

UiPath.Excel.Activities.InsertChart

note

This activity is available in preview.

Inserts a chart into an Excel file. This is the cross-platform equivalent of the Insert Chart Windows-only activity.

note

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

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

Chart categoryChart types
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
  • 100% Stacked Line
  • Stacked Line with Markers
  • 100% Stacked Line with Markers
Pie
  • Pie
  • Doughnut
Scatter
  • Scatter
  • Scatter with Smooth Lines
  • Scatter with Smooth Lines and Markers
  • Scatter with Straight Lines
  • Scatter with Straight Lines and Markers

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.
  • Use table source - Toggle to switch between using a sheet range or a named table as the data source.
    • When you disable this option, the following fields are displayed:
      • Source sheet - The sheet containing the source data for the chart.
      • Source range - The range containing the source data for the chart.
    • When you enable this option, the following field is displayed:
      • Source table name - The name of the table that contains the source data.
  • Insert into sheet - The sheet in which to insert the chart.
  • Chart category - Select one of the following categories of the chart to insert:
    • Area
    • Bar
    • Column
    • Line
    • Pie
    • Scatter
  • Chart type - Select one of the following chart types based on the selected chart category:
    • Clustered Column
    • Stacked Column
    • 100% Stacked Column

Use Workbook

  • Workbook - The existing workbook to use.

Input

  • Chart height - The height of the chart, in points.
  • Chart width - The width of the chart, in points.
  • Chart left - The distance from the left edge of the sheet to the chart insertion point, in points.
  • Chart top - The distance from the top of the sheet to the chart insertion point, in points.

Options

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

Output

  • Save chart to - The name of the inserted chart, available for use in other activities such as Update Chart Workbook.