Pivot Table Setup

General Productivitychatgpt-prompts-for-excelcol_adesc_aexamples_a

Describing the data as a table with examples gives the AI concrete context. Asking for the chart recommendation turns a data question into a visual insight.

Prompt

Help me create a pivot table in Excel:

**Raw data structure:**
| Column | Description | Example values |
|--------|-------------|----------------|
| {{col_a}} | {{desc_a}} | {{examples_a}} |
| {{col_b}} | {{desc_b}} | {{examples_b}} |
| {{col_c}} | {{desc_c}} | {{examples_c}} |

**Analysis question:** {{what_you_want_to_know}}

Tell me:
1. Which field goes in Rows, Columns, Values, and Filters
2. What aggregation to use (Sum, Count, Average, etc.)
3. Any calculated fields I should add
4. Recommended chart type to visualize the result
5. Step-by-step instructions to set it up

Variables to customize

{{col_a}}{{desc_a}}{{examples_a}}{{col_b}}{{desc_b}}{{examples_b}}{{col_c}}{{desc_c}}{{examples_c}}{{what_you_want_to_know}}

Why this prompt works

Describing the data as a table with examples gives the AI concrete context. Asking for the chart recommendation turns a data question into a visual insight.

What you get when you save this prompt

Your workspace unlocks powerful tools to iterate and improve.

AI OPTIMIZE

AI Optimization

One-click improvement with structure analysis and pattern suggestions.

VERSION DIFF

Version History

Track every edit. Compare versions side-by-side with word-level diffs.

ORGANIZE

Development

Code Review

Testing

Marketing

Folders & Tags

Organize your library with nested folders, tags, and drag-and-drop.

MCP

$ npm i -g @promptingbox/mcp

Claude · Cursor · ChatGPT

Use Everywhere

Access prompts from Claude, Cursor, ChatGPT & more via MCP integration.

Your prompts, organized

Save, version, and access your best prompts across ChatGPT, Claude, Cursor, and more.