# manage_charts

Manages embedded charts. action=add builds a chart from chart_type (COLUMN/BAR/LINE/AREA/STEPPED_AREA/SCATTER/PIE), domain_range (x-axis labels / pie labels), series_ranges (one grid range per data series; PIE takes exactly one) and optional title/legend_position/header_count (rows of the ranges treated as headers, default 1) — place it with anchor {sheet_id,row_index,column_index} (the cell under the chart's top-left corner) or new_sheet=true for its own chart sheet; the reply carries the new chartId. Ranges should be single columns (or rows) including the header cell. For chart kinds beyond the basic set (combo, waterfall, histogram, org …) pass a raw Sheets API ChartSpec via spec instead — it overrides the simplified fields. action=update REPLACES the whole spec of an existing chart (chart_id + the same spec-building fields; there is no partial chart update). action=delete removes the chart by chart_id. Find chartIds via get_spreadsheet (sheets[].charts).

Agent View of the PolicyLayer registry record for `manage_charts`. HTML page: https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-charts

## Facts

- Tool: `manage_charts`
- Server: Mcp Google Sheets (`@a1-x-tech/mcp-google-sheets`) — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets.md
- Install: `npx -y @a1-x-tech/mcp-google-sheets`
- Homepage: https://github.com/A1-x-Tech/mcp-google-sheets
- Risk category: Write (Medium risk)
- Registry record: grade F, identity unverified
- Server rate-limited: no
- Parameters: 12 (2 required)
- Recommended policy verdict: Rate-limited

## Parameters

| Parameter | Type | Required | Description |
| --- | --- | --- | --- |
| `spec` | object | no | Raw Sheets API ChartSpec — full control; overrides the simplified fields above. |
| `title` | string | no | Chart title. |
| `action` | string | yes | What to do with the charts. |
| `anchor` | object | no | add: place the chart over the grid, top-left at this cell. |
| `chart_id` | integer | no | update/delete: the chartId from get_spreadsheet or the add reply. |
| `new_sheet` | boolean | no | add: put the chart on its own new chart sheet instead. |
| `chart_type` | string | no | add/update: the chart kind (required unless spec is given). |
| `domain_range` | object | no | The x-axis (or pie label) values, incl. header cell. |
| `header_count` | integer | no | How many leading rows of the ranges are headers (default 1). |
| `series_ranges` | array | no | One range per data series, incl. header cells (PIE: exactly one). |
| `spreadsheet_id` | string | yes | The spreadsheet id — the long id from the URL (docs.google.com/spreadsheets/d/<spreadsheetId>/edit) or from create_spreadsheet / search_spreadsheets output. |
| `legend_position` | string | no | BOTTOM_LEGEND, LEFT_LEGEND, RIGHT_LEGEND, TOP_LEGEND or NO_LEGEND (default: API's choice). |

Parameters from the server's own tool schema.

## Example call (MCP tools/call, JSON-RPC 2.0)

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "manage_charts",
    "arguments": {
      "action": "<action>",
      "spreadsheet_id": "<spreadsheet_id>"
    }
  }
}
```

## Why manage_charts is rated Medium

Creates and modifies chart objects in spreadsheets, reversibly. No data deletion or financial operations.

From the tool's own definition: "Manages embedded charts. action=add builds a chart from chart_type, places it with anchor or new_sheet"

Risk signals: High parameter count (25 properties)

## Use case

AI agents use manage_charts to create or update resources in Mcp Google Sheets, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Mcp Google Sheets environment.

## Recommended policy (PolicyLayer)

Verdict: **Rate-limited**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Mcp Google Sheets:

```json
{
  "version": "1",
  "default": "deny",
  "tools": {
    "manage_charts": {
      "limits": [
        {
          "counter": "manage_charts_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}
```

## Other tools on Mcp Google Sheets (19)

- `clear_values` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/clear-values.md
- `manage_dimensions` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-dimensions.md
- `manage_sheets` — Destructive — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-sheets.md
- `raw_request` — Execute — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/raw-request.md
- `append_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/append-values.md
- `get_spreadsheet` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/get-spreadsheet.md
- `read_values` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/read-values.md
- `search_spreadsheets` — Read — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/search-spreadsheets.md
- `batch_write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/batch-write-values.md
- `create_spreadsheet` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/create-spreadsheet.md
- `format_cells` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/format-cells.md
- `manage_conditional_formats` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-conditional-formats.md
- `manage_permissions` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-permissions.md
- `manage_protected_ranges` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-protected-ranges.md
- `manage_tables` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/manage-tables.md
- `set_borders` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-borders.md
- `set_data_validation` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-data-validation.md
- `set_frozen` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/set-frozen.md
- `write_values` — Write — https://policylayer.com/tools/a1-x-tech-mcp-google-sheets/write-values.md

## For agents

This record is a snapshot. Live verdicts and the full registry:

- Check every server in your MCP config at once: `npx -y policylayer stack`
- Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md)
- Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events`

---

Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=a1-x-tech-mcp-google-sheets · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/a1-x-tech-mcp-google-sheets