create_chart
Create embedded charts in Google Sheets with multi-series support. Select bar, column, line, pie, area, or scatter types to visualize spreadsheet data.
Instructions
Create an embedded chart with MULTIPLE SERIES support.
Examples: - Multi-series line chart (auto-detect all columns B-F as series): create_chart("abc", 0, "LINE", "Sheet1!A1:F10", "Stock Prices")
- Explicit series columns (B=1, C=2, D=3, E=4 as separate lines):
create_chart("abc", 0, "LINE", "A1:E10", "Comparison", 0, 7, 0, "1,2,3,4")
- Pie chart (single series from column B):
create_chart("abc", 0, "PIE", "A1:B5", "Distribution")Chart Types: - BAR: Horizontal bars (multiple series = grouped bars) - COLUMN: Vertical bars (multiple series = grouped columns) - LINE: Line graph (multiple series = multiple lines, great for trends) - PIE: Circular chart (single series only) - AREA: Stacked area chart - SCATTER: X-Y scatter plot
Multi-Series Example: Data: | Date | ONGC | BPCL | IOCL | NTPC | CIL | Range: "Sheet1!A1:F30" domain_column: 0 (Date column as X-axis) series_columns: "1,2,3,4,5" (or leave empty to auto-detect) Result: 5 lines on one chart, each representing a company
Args: spreadsheet_id: The ID from the spreadsheet URL. sheet_id: Numeric sheet ID where chart will be placed. chart_type: BAR, LINE, PIE, AREA, COLUMN, or SCATTER. data_range: A1 notation of data range (e.g., "Sheet1!A1:F30"). title: Chart title displayed at top. position_row: Row offset for chart placement (0-based). position_col: Column offset for chart placement (0=A, 5=F, 7=H). domain_column: Column index for X-axis labels (0=first column of range). series_columns: Comma-separated indices for series data (e.g., "1,2,3,4,5"). Empty = auto-detect all columns after domain_column.
Returns: JSON with chart_id for later reference.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | No | ||
| sheet_id | Yes | ||
| chart_type | Yes | ||
| data_range | No | ||
| position_col | No | ||
| position_row | No | ||
| domain_column | No | ||
| series_columns | No | ||
| spreadsheet_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |