Pivot Table Setup
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.
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
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.
Save this prompt to your library
Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.
Related prompts
Forcing the agent to plan before acting prevents premature execution and wasted steps. Explicit dependency mapping enables parallel execution and catches logical gaps early.
Tool Selection AgentThe ReAct pattern (Reason + Act) creates an explicit reasoning trace that improves tool selection accuracy. The error-handling rule prevents infinite retry loops.
Prompt CompressorExplicitly requiring all functional requirements to be preserved prevents the model from over-compressing and losing critical instructions.
Memory Management AgentExplicit memory read/write instructions create agents that improve over time. Categorization keeps memories organized, and the deduplication rule prevents context bloat.