create_chart
Insert native bar, line, pie, or scatter charts into Excel .xlsx sheets from selected data ranges, with optional category labels and titles.
Instructions
Create a native Excel chart (bar, line, pie, scatter).
Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. chart_type: One of "bar", "line", "pie", "scatter". data_range: A1-style range holding the chart series values (e.g. "B1:B10"). categories_range: Optional A1-style range holding series category labels (e.g. "A2:A10"). title: Title string displayed on the chart. target_cell: Cell coordinate where the top-left corner of the chart is placed. backup: Whether to create a backup before modifying the workbook.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | No | ||
| sheet | Yes | ||
| title | No | Chart | |
| backup | No | ||
| chart_type | Yes | ||
| data_range | Yes | ||
| target_cell | No | E2 | |
| categories_range | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||