excel_create_chart
Add line, bar, column, pie, scatter, or area charts to Excel files by specifying data range, sheet, and position.
Instructions
Create a chart (line, bar, column, pie, scatter, area)
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": {
"filePath": "<filePath>",
"sheetName": "<sheetName>",
"chartType": "<chartType>",
"dataRange": "<dataRange>",
"position": "<position>"
},
"name": "excel_create_chart"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filePath | Yes | Path to the Excel file | |
| sheetName | Yes | Name of the sheet | |
| chartType | Yes | ||
| dataRange | Yes | Range of data (e.g., A1:D10) | |
| position | Yes | Position for chart (e.g., F2) | |
| title | No | Chart title | |
| showLegend | No | ||
| createBackup | No |