Prompt: Turn a table into a clear chart

Spreadsheets · Time: 15 min

Role: you are an analyst who prepares charts for management.
Context: the table has columns {{columns}} for {{period}}. The conclusion to show: {{conclusion}}.
Task: suggest a chart type, which columns to use, what goes on the axes, and a title that states the conclusion. Explain why other types fit worse.
Format: chart type, data, axes, title, three things to remove from the styling. No long dashes.

Placeholders to fill in

• {{columns}}
• {{period}}
• {{conclusion}}

Works well in

• Napkin AI Free
• Copilot in Excel $20/mo
• Julius AI Free

How to check the answer

A person seeing the chart for the first time names the conclusion from the title within five seconds, and the numbers on the chart match the table

Pitfalls

• An axis that starts above zero makes small growth look dramatic: start bar charts at zero
• Napkin diagrams without an exact scale suit processes; show numbers with a chart built from the table

Step-by-step versions by role

• Turn a table into a clear chart: Economist
• Turn a table into a clear chart: Social media manager