Insert Chart
Adds a chart of a range to a sheet in Microsoft Excel and saves the workbook. Needs Excel installed.
Behaviour
Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash
Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.desktop.insertChart
Properties#
Input#
Workbook Path#
WorkbookPath · String · Required · Default: Not specified in package metadata
The .xlsx, .xlsm, .xlsb or .xls file. Relative paths resolve against the project folder.
Sheet#
Sheet · String · Required · Default: Sheet1
The sheet that gets the chart.
Data Range#
DataRange · String · Required · Default: Not specified in package metadata
The chart's data on that sheet, headers included.
Chart Type#
ChartType · String · Optional · Default: Column
The kind of chart.
Allowed values: Column, Bar, Line, Pie, Area, Scatter, Doughnut.
Title#
Title · String · Optional · Default: Not specified in package metadata
The chart title. Empty shows none.
Position#
Position · String · Optional · Default: Not specified in package metadata
The cell at the chart's top-left corner. Empty places it right of the data.
Width#
Width · Double · Optional · Default: 480
The width in points.
Height#
Height · Double · Optional · Default: 288
The height in points.
Output#
Chart Name#
ChartName · String · Output
The name Excel gave the chart.
Retry and risk#
This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.
Every activity also has the engine's common properties: Timeout and Continue On Error.
Related activities#
Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel Desktop. Keywords: excel, chart, graph, plot, insert, column, bar, line, pie, desktop.
Properties
Input
Output
Retry and risk
Related activities