create_chart
Create a chart in an Excel worksheet by specifying sheet, data range, chart type, and target cell, with optional title and axis labels.
Instructions
Create chart in worksheet.
Args:
sheet_name: Name of worksheet
data_range: Data range for chart
chart_type: Type of chart
target_cell: Cell where chart will be placed
session_id: Session ID from open_workbook (preferred)
filepath: Path to Excel file (legacy, deprecated)
title: Chart title (optional)
x_axis: X-axis label (optional)
y_axis: Y-axis label (optional)
Note: Use session_id for better performance. filepath parameter is deprecated.
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": {
"sheet_name": "<sheet_name>",
"data_range": "<data_range>",
"chart_type": "<chart_type>",
"target_cell": "<target_cell>"
},
"name": "create_chart"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_name | Yes | ||
| data_range | Yes | ||
| chart_type | Yes | ||
| target_cell | Yes | ||
| session_id | No | ||
| filepath | No | ||
| title | No | ||
| x_axis | No | ||
| y_axis | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |