Add a real Excel chart to a sheet. Needs Windows with Microsoft Excel installed. Put this step last: a later Excel step rewrites the file and drops the chart
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Chart Type chartType | enum | Required | Column | —ColumnStacked ColumnBarStacked BarLinePieDoughnutAreaScatter |
Data Sheet sheetName | string | Optional | — | The sheet holding the data. Leave empty for the first sheet. |
Data Range dataRange | string | Optional | — | For example A1:C20. Leave empty to chart everything on the sheet. |
Chart Title title | expression | Optional | — | — |
Put Chart On targetSheetName | string | Optional | — | Leave empty to place it beside the data |
Top-Left Cell anchorCell | string | Optional | E2 | Where the chart's top-left corner sits |
Width width | number | Optional | 480 | — |
Height height | number | Optional | 300 | — |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create Summary Table
Group and total data into a summary table. Works without Excel; for a live pivot use Insert Pivot Table
Export Chart as Image
Write a chart out as a picture, for an email or a document where the reader will not have the workbook. Needs Windows with Microsoft Excel installed
Insert Pivot Table
Add a live PivotTable with a field list and slicers. Needs Excel installed on Windows. Put this step last: a later Excel step rewrites the file and drops the pivot
Update Chart
Re-point an existing chart at different data, or retitle it, keeping the position, colours and axis scale a reader set by hand. Needs Windows with Microsoft Excel installed
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row