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
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | The sheet the chart is on. Leave empty for the first sheet |
Chart Name chartName | string | Optional | — | Leave empty when the sheet has only one chart |
Image File Path imagePath | file | Required | — | The picture to write, such as C:\Reports\chart.png |
Format imageFormat | enum | Optional | — | Leave unset to take it from the file namePNGJPGGIF |
Output Variable outputVariable | variable | Optional | ChartImagePath | — |
Output
$outputVariableStringThe path of the picture that was written
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
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
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