Skip to main content
Glama

create_chart

Insert native bar, line, pie, or scatter charts into Excel .xlsx sheets from selected data ranges, with optional category labels and titles.

Instructions

Create a native Excel chart (bar, line, pie, scatter).

Args: path: Path to the .xlsx file, or the name of a preloaded file. Omit if only one file is configured. sheet: Sheet name. chart_type: One of "bar", "line", "pie", "scatter". data_range: A1-style range holding the chart series values (e.g. "B1:B10"). categories_range: Optional A1-style range holding series category labels (e.g. "A2:A10"). title: Title string displayed on the chart. target_cell: Cell coordinate where the top-left corner of the chart is placed. backup: Whether to create a backup before modifying the workbook.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
pathNo
sheetYes
titleNoChart
backupNo
chart_typeYes
data_rangeYes
target_cellNoE2
categories_rangeNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv0.3.0

TDQS

A3.9/5.0
Behavior3/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full burden. It does signal a mutating operation via 'backup: Whether to create a backup before modifying the workbook,' which usefully implies the workbook is written in place. However it omits permissions, error behavior for invalid ranges, and whether the file must already exist.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The purpose sentence is front-loaded and the Args list is compact and scannable, with each line adding distinct parameter meaning. No filler or redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

An output schema exists, so return values need not be explained, and all 8 parameters are fully covered. The remaining gap is usage/permission context for a write operation, which is modest against the otherwise thorough documentation.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must fully compensate, and it does: all 8 parameters are documented with real semantics, including the 'omit if only one file is configured' note for path, optional status of categories_range, and A1-style examples for the range parameters.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

States a specific verb and resource ('Create a native Excel chart') and immediately enumerates the supported chart types (bar, line, pie, scatter). No sibling tool creates charts, so the resource alone distinguishes it from create_table, create_sheet, and create_workbook.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description says nothing about when to choose this tool versus alternatives or prerequisites (e.g., does the target sheet/file need to exist first?). The only guidance is embedded in parameter text, not in usage framing.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.