create_chart
Visualize data by creating an embedded chart in a Google Sheet using specified chart type and data ranges.
Instructions
Create an embedded chart from existing sheet data.
chart_type: COLUMN, BAR, LINE, AREA, SCATTER,
COMBO, STEPPED_AREA, PIE, or DONUT.
domain_range is the category/label range; series_ranges is one or
more value ranges. Each source must be a single row or single column, e.g.
Sheet1!A2:A10 plus Sheet1!B2:B10. Ranges without a sheet prefix use
sheet. anchor_cell is where the chart is overlaid on that sheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | ||
| title | No | ||
| pie_hole | No | ||
| chart_type | Yes | ||
| anchor_cell | No | E2 | |
| domain_range | Yes | ||
| header_count | No | ||
| stacked_type | No | ||
| width_pixels | No | ||
| x_axis_title | No | ||
| y_axis_title | No | ||
| height_pixels | No | ||
| series_ranges | Yes | ||
| spreadsheet_id | Yes | ||
| legend_position | No | RIGHT_LEGEND | |
| offset_x_pixels | No | ||
| offset_y_pixels | No | ||
| three_dimensional | No |