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
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Sheet Name sheetName | string | Optional | Not set | The sheet the chart is on. Leave empty for the first sheet |
Chart Name chartName | string | Optional | Not set | Leave empty when the sheet has only one chart |
New Data Range dataRange | string | Optional | Not set | For example A1:C20 |
New Title title | string | Optional | Not set | |
New Chart Type chartType | enum | Optional | Not set | ColumnColumn StackedBarBar StackedLineLine PlainPieDoughnutAreaScatter |
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 Chart
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
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
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