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.
Feb 6, 2026
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".