add_chart
Create a chart from a specified cell range in an open Excel workbook, with optional chart type, title, sheet, and workbook settings. Returns the chart name and title.
Instructions
Create a chart from a range. Chart types: ColumnClustered, ColumnStacked, BarClustered, BarStacked, Line, LineMarkers, Pie, Doughnut, Area, XYScatterLines. Returns the chart name and title.
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": {
"range": "<range>"
},
"name": "add_chart"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range address with the data (and labels) to plot. | |
| title | No | Chart title. Empty string removes the title. | |
| chartType | No | Chart type. Default ColumnClustered. | |
| sheetName | No | Worksheet name. Defaults to the active worksheet. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |