> ## Documentation Index
> Fetch the complete documentation index at: https://docs.markifact.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create Chart

> Create a chart / graph in a Google Sheet

Create a chart / graph in a Google Sheet. Supported chart types: column, line, bar, area, or pie. Set its alt text to retrieve later and embed into Google Slides presentations.

|                      |                       |
| -------------------- | --------------------- |
| **App**              | Google Sheets         |
| **Operation ID**     | `sheets_create_chart` |
| **Type**             | Action                |
| **Connection**       | `drive` (optional)    |
| **Credits per run**  | 1                     |
| **Agent / MCP tool** | Yes                   |

## Inputs

| Field         | Type                 | Required | Default  | Description                                                                                                                                                                                                                                                                        |
| ------------- | -------------------- | -------- | -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `spreadsheet` | string               | Yes      | -        | Google Sheets spreadsheet URL or ID. You must ask the user for it if not provided.                                                                                                                                                                                                 |
| `sheet`       | string or SelectItem | Yes      | -        | The sheet where the chart will be created. Accepts a sheet name or sheet ID formats like other sheet operations.                                                                                                                                                                   |
| `chart_title` | string               | No       | -        | Title to display on the chart. Optional.                                                                                                                                                                                                                                           |
| `alt_text`    | string               | No       | -        | Alt text (description) to assign to the chart. Helps retrieve/embed the chart later using Get Chart or Slides Add Sheets Chart operations. If omitted, you can still reference the chart by its ID once created.                                                                   |
| `range`       | string               | Yes      | -        | Data range in A1 notation (single contiguous block) including headers, e.g. "A1:D20" or "A1:B10". First row is treated as headers. First column becomes the domain (labels). Remaining columns become data series. For PIE charts you need at least two columns (labels + values). |
| `chart_type`  | string               | No       | `COLUMN` | Basic chart type. Supported: COLUMN, LINE, AREA, BAR, PIE.                                                                                                                                                                                                                         |

### SelectItem

| Field   | Type   | Required | Default | Description                                                                                          |
| ------- | ------ | -------- | ------- | ---------------------------------------------------------------------------------------------------- |
| `value` | string | Yes      | -       | The value of the selectable item.                                                                    |
| `label` | string | Yes      | -       | The label of the selectable item, used for display purposes. If not provided, defaults to the value. |

## Output

**Type**: `Dict`

Returns created chart details.

**Fields**: `message`, `chart_id`, `spreadsheet_id`, `sheet_id`, `sheet_name`, `alt_text`, `chart_type`, `title`