Add a chart
xlide_add_chartAdd a chart from a cell range to an Excel worksheet and save the workbook. Specify sheet, data range, chart type, position, and size.
Instructions
Adds a chart of a block of cells to a worksheet and saves the workbook, written as Excel's Insert Chart writes one of the same type. The block's first row names the series and its first column holds the categories, as Excel reads a selection; a block taller than it is wide makes a series of each column. The data can be on another sheet, as Data!A1:C13. Place it with cell or left and top in points. xlide_list_shapes reports it afterwards with each series' formula.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Without cell: points from the top. | |
| cell | No | The chart's top-left cell, such as H2. | |
| left | No | Without cell: points from the left. | |
| sheet | Yes | Worksheet the chart goes on. | |
| title | No | The title. Empty keeps Excel's automatic one. | |
| width | No | Points. 0 gives Excel's 360. | |
| height | No | Points. 0 gives Excel's 216. | |
| file_path | Yes | Absolute path to the Excel file. | |
| series_in | No | 'columns' or 'rows' to say which way the series run. Empty decides. | |
| chart_name | No | Its name. Empty gives Chart 1, Chart 2 and so on. | |
| chart_type | No | column, bar, line, lineMarkers, pie, doughnut, scatter or area. | column |
| data_range | Yes | The block to chart, header row and category column included. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||