Create Chart
create_chartCreate a chart from a specified cell range in an open Excel workbook, choosing from column, bar, line, pie, area, scatter, or doughnut types, with optional title and positioning. Returns the new chart's name.
Instructions
Create a chart from a range.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: Source data range, e.g. "A1:C10". chart_type: One of "column_clustered", "bar_clustered", "line", "pie", "area", "scatter", "doughnut". title: Chart title (None = no title). chart_name: Name for the new chart (None = Excel's default, e.g. "Chart 1"). left, top, width, height: Position and size in points.
Returns: JSON with the new chart's name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | ||
| left | No | ||
| sheet | No | ||
| title | No | ||
| width | No | ||
| height | No | ||
| workbook | No | ||
| chart_name | No | ||
| chart_type | No | column_clustered | |
| range_address | No | A1 |