office_chart_tool
Add bar, line, or pie charts to XLSX sheets or PPTX slides by providing categories, values, and placement; the chart is saved directly to the file.
Instructions
Add a bar, line, or pie chart to an xlsx sheet or a pptx slide.
For xlsx, data_range is the values including the series title, for example B1:B4, and categories_range is the labels, for example A2:A4. anchor is the cell where the chart sits, for example E2. For pptx, categories and values are comma-separated lists of the same length, such as Jan,Feb and 10,12.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| sheet | No | ||
| slide | No | ||
| title | No | ||
| anchor | No | E2 | |
| values | No | ||
| categories | No | ||
| chart_type | No | bar | |
| data_range | No | ||
| series_name | No | ||
| categories_range | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |