How to Create Charts and Insights with Claude in Excel
Ask Claude in Excel to recommend chart types, summarize trends, and build clear data stories.
2026/02/06
When this guide helps
Use this guide when you want a fast, clear visual summary of trends, comparisons, or distributions.
Step-by-step workflow
1. Ask for the best chart type
Prompt:
Based on columns A (month) and F (revenue), recommend the best chart type and explain why.2. Create a chart-ready summary
Prompt:
Create a summary table that groups revenue by month and region. Put the output in a new sheet called "Chart Data".3. Generate insight bullets
Prompt:
Review the summary table and write 3 to 5 insight bullets that describe trends or anomalies.4. Validate the visual logic
Prompt:
Double-check if any months are missing from the chart data and list them.Practical tips
- Keep chart data in a clean, separate table for easier updates.
- Ask Claude to label axes and suggest a short chart title.
Common pitfalls
- Charting raw data directly can create noisy visuals.
- If categories are too many, ask Claude to show the top 5 and group the rest as "Other".