add_excel_chart
Add bar, line, or pie charts to Excel sheets using a specified data range and title. Place charts at a chosen cell position.
Instructions
Create a chart in an Excel sheet.
Args: path: Path to the .xlsx file sheet_name: Sheet name chart_type: bar, line, or pie data_range: Cell range (e.g., 'A1:B10') title: Chart title position: Cell to place chart (e.g., 'E5')
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"sheet_name": "<sheet_name>",
"chart_type": "<chart_type>",
"data_range": "<data_range>"
},
"name": "add_excel_chart"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| title | No | ||
| position | No | E5 | |
| chart_type | Yes | ||
| data_range | Yes | ||
| sheet_name | Yes |