sheets_add_chart
Add a chart to a Google Sheet by specifying a data range, chart type, and placement options. Choose from bar, line, pie, column, area, or scatter charts to visualize data directly in a spreadsheet.
Instructions
Create a chart in a Google Sheet from a data range.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | No | Optional chart title. | |
| account | Yes | Account id. | |
| anchor_col | No | Column index (0-based) to anchor the chart (default 0). | |
| anchor_row | No | Row index (0-based) to anchor the chart (default 0). | |
| chart_type | Yes | Chart type. | |
| data_range | Yes | A1 notation range for chart data, e.g. "A1:B10". First column = labels, second = values. | |
| sheet_title | Yes | Sheet tab where the chart will be placed. | |
| width_pixels | No | Chart width in pixels (default 600). | |
| height_pixels | No | Chart height in pixels (default 400). | |
| spreadsheet_id | Yes | Spreadsheet ID. |