Skip to main content
prompt GP ChatGPT

shape-image — Claude Code prompt for spreadsheet shapes

The shape-image prompt guides Claude Code in adding shapes, labels, and in-cell trend charts to spreadsheets. Use it to annotate key figures or show a data pattern without adding chart objects.

Apache-2.0 ★ 12,746 updated 2026-10-29

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/commands/shape-image.md
Open on GitHub

What shape-image does

The prompt covers shape operations with a type, anchor cell, optional fill color, and text. It also gives formula patterns for line, column, and win/loss SPARKLINE charts, plus IMAGE for embedding a picture. For clickable links, it points to set_hyperlink.

Shape operations can be batched with content and formatting changes, but not structural operations. This mode applies to imported xlsx files, and changes are written with ⌘S. So a new workbook does not meet that requirement. The guide distinguishes formula-driven sparklines from chart objects, which sit on separate layers.

What it helps with

  • place a text callout beside a key cell
  • build a flow diagram from rectangles and arrows
  • frame a group of metrics with a filled shape
  • show a row’s trend inside a cell
  • add an embedded image or clickable link

Example prompts for the agent

  • Add a text callout beside the key metric with a short explanation.
  • Show the values in B2:M2 as a column sparkline in N2.
  • Build a process diagram from rectangles and arrows on sheet s1.

How to install shape-image

Manually: put the files in place

.claude/commands/shape-image.md

Questions about shape-image

How do I install shape-image in Claude Code?

Save the prompt at .claude/commands/shape-image.md in your project.

What does shape-image do?

It guides Claude Code through adding spreadsheet shapes, text boxes, in-cell sparklines, and images. Trend lines use the SPARKLINE formula.

Can shape-image add shapes to a new xlsx workbook?

The documented shape workflow is for imported xlsx files. Save its changes with ⌘S.

Source text

shape-image.md · Apache-2.0
# Shapes & images guide (shape-image)

## Inserting a shape/text box (supported)

`{op:"add_shape", sheetId, shapeType, anchorCell:"E2", fillColor?, text?}`

- shapeType: any OOXML prstGeom name from the insert gallery — rectangles ("rect", "roundRect", snip/round corner variants), basic shapes ("ellipse", "triangle", "diamond", "hexagon", "heart", "cloud", "donut", "smileyFace", …), block arrows ("rightArrow", "quadArrow", "chevron", …), stars/banners ("star5", "star12", "ribbon", "wave", …), flowchart nodes ("flowChartProcess", "flowChartDecision", "flowChartDocument", …), callouts ("wedgeRectCallout", "cloudCallout", …), or "textbox"
- textbox defaults to a white background with "Text"; other shapes default to a light-blue fill. text can carry the annotation directly.
- Layout-class: can share a batch with content/format, not with structural operations; only works on imported xlsx, written with ⌘S.

### Common uses

- **Callout/annotation boxes**: put a `textbox` next to key data with the interpretation as text (e.g. "+23% YoY, all-time high").
- **Flow/relationship diagrams**: combine `rect`/`roundRect` + `rightArrow`, staggering anchorCells for layout.
- **Emphasis blocks**: a `roundRect` with a translucent fill framing a group of key metrics.

## In-cell sparklines (SPARKLINE, supported)

No chart object needed — draw a mini trend chart inside a cell with a formula:

- Line sparkline: `=SPARKLINE(B2:M2)`
- Column sparkline: `=SPARKLINE(B2:M2, {"charttype","column"})`
- Win/loss: `=SPARKLINE(B2:M2, {"charttype","winloss"})`

Great for a "Trend" column at the end of each summary row — the trend is visible at a glance and is lighter than inserting many charts.

```json
{
  "op": "set_formula",
  "sheetId": "s1",
  "address": "N2",
  "formula": "=SPARKLINE(B2:M2,{\"charttype\",\"column\"})"
}
```

## In-cell images / links (supported)

- Embedded image: `=IMAGE("https://example.com/logo.png")`
- Clickable link: prefer `set_hyperlink` (see the data guide); formula version `=HYPERLINK("https://...", "Click here")`.

## Rules

- Shapes/images are for **supporting expression** — don't let them upstage the data; correctness first.
- Sparklines/IMAGE are formulas that update with their cell's values; chart objects are independent layers (see the charts guide).
- For lots of trend displays prefer SPARKLINE (light); for a single focused analysis use add_chart (heavy).

© genspark-ai · Apache-2.0 · genspark-ai/genoffice

Similar prompts

Prompts catalog →

From the same set65

The whole set →
deep-research deep-research splits research topics into targeted sub-questions, verifies figures across independent sources, and exports a cited Word document. CX Codex +1 ★ 12,746repo stars qc-geometry The qc-geometry prompt fixes slide geometry defects backed by audit findings. Use it to check a slide when the model cannot inspect its rendered image. GP ChatGPT ★ 12,746repo stars contract-drafter contract-drafter turns a rough brief into a Word contract draft, then lists the clauses that could bite you before signing. CX Codex +1 ★ 12,746repo stars qc-visual qc-visual inspects slide layouts to fix overlaps, bad contrast, and alignment issues from screenshots. Keeps original copy, palettes, and fonts intact. GP ChatGPT ★ 12,746repo stars _format Defines the authoring format for ops/*.md files that document canonical edit operations in the genoffice slide editor. GP ChatGPT ★ 12,746repo stars data-attribution The data-attribution prompt for Claude Code defines how to cite external sources in spreadsheets, using a Source column, a footer block, or a separate Sources sheet. GP ChatGPT ★ 12,746repo stars meeting-minutes The meeting-minutes skill for Claude Code turns transcripts, chats, or rough notes into a Word meeting record with decisions and assigned tasks. It gives a discussion a clear written follow-up. CX Codex +1 ★ 12,746repo stars okr-planner okr-planner splits a team's goals into measurable objectives and key results, then hands back an Excel workbook with an alignment sheet and a review log. CX Codex +1 ★ 12,746repo stars

More in the catalog

Project sponsors

Companies that keep this analytics open