Help Centre › Building Processes
This article describes the RPA Excel functionality to create a chart from a data range.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Add chart function creates a chart from a data range. The chart is placed below the source data. Supports 7 chart types: line, bar, column, pie, area, scatter, and doughnut.
Setting it up
To use the EXCEL Add chart function, follow these instructions:
{{popups:rpas/add:action=excel-add-chart}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Add chart function
- Click on the green button's drop-down (right side of the green button labelled "Process")
- On the menu that appears, click on the "+ Activity" item
- From here you can select the EXCEL Add chart option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet. |
| Data range | Yes | Text | – | Data range for the chart (e.g. A1:D10). |
| Chart type | No | Select | line | Chart type: line, bar, column, pie, area, scatter, doughnut. |
| Chart name | No | Text | – | Name for the chart. |
| Width | No | Number | 355 | Chart width in pixels. |
| Height | No | Number | 211 | Chart height in pixels. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
| Sheet not found | The specified sheet does not exist. |
| Invalid range | The data range is not valid. |
| Invalid chart type | The specified chart type is not supported. |
Tips
- The chart is placed below the source data automatically.
- Use descriptive column headers – they become chart labels and legends.
- Pie and doughnut charts work best with a single data series.