Turn Pasted Spreadsheet Data into Three Charts with Takeaway Titles
Paste your spreadsheet data and get three chart recommendations, each with a chart type, axis setup, a title that states the finding, and a confidence rating.
You getTakeaway title, chart type and why and X axis
Prompt
You are a data visualization analyst who prepares charts for business presentations.
I will paste spreadsheet data right after this message. It may be copied cells, CSV or a table. Recommend three charts, each showing a different insight from the data.
Rules:
1. Each chart makes a distinct point. Do not show the same finding in two chart shapes.
2. Write each title as a full sentence that states the finding and includes a number, such as "Online sales grew 46% in six months." Do not use labels like "Sales by Month."
3. Match the chart type to the comparison:
- line for change over time
- bar for ranking or comparing categories
- stacked or 100% bar for parts of a whole
- scatter for relationships
No 3D charts, and no pie charts with more than 4 slices.
4. Use only numbers that are in the data or calculated from it, and show each calculation.
5. Flag thin evidence. This includes fewer than 6 data points, a single period, one outlier driving the result, or missing values. When evidence is thin, say so and soften the title.
Output format:
For charts 1 to 3:
- Takeaway title
- Chart type and why
- X axis, Y axis and series, using the exact column names
- Supporting calculation
- Confidence: High, Medium or Low, with a one-line reason
Then add "Data gaps": up to 4 bullets on what missing data would make these charts more reliable.
If the data has no headers or mixed units, ask up to 3 numbered questions first and wait for my answers.Example output
Tips and common edits
Why this works
- Takeaway titles with a number force each chart to state a finding instead of naming a topic.
- Fixed rules for matching chart type to comparison stop default pie charts and mismatched visuals.
- The thin-evidence rule makes the model downgrade confidence and soften claims instead of overselling a weak pattern.
Use before building a slide deck or report. Have your table ready to paste: headers plus rows, copied from Excel or Google Sheets. Works in ChatGPT, Claude or Gemini.
Common edits
- Ask for five charts instead of three for a longer report.
- Add your audience, such as "for a board meeting," so titles focus on money and risk.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Prepare for Presentation Q&A with 10 Tough Questions and 30-Second Answers
Get 10 likely tough audience questions ranked by likelihood and difficulty, a 30-second answer for each, and clear flags where you lack evidence.
Rewrite a Wordy Slide into a Clear Headline and Three Tight Bullets
Turns one crowded slide into a one-sentence takeaway headline, three bullets under 10 words, and speaker notes that keep every detail you cut.
Turn a Long Report into a One-Page Executive Summary That Leads with the Ask
Returns a one-page executive summary that opens with the decision needed, keeps every source number exact, and lists claims the report does not back up.
Build a 30-Day Learning Plan for a New Skill with Weekly Project Milestones
You get a 30-day plan sized to your daily time, with one small, checkable project each week, day-by-day tasks with minutes, and a catch-up plan.
Build a Practice Quiz with Answer Key from Your Course Notes
Paste your course material and get a practice quiz that mixes recall, application and misconception questions, plus a separate answer key that explains every wrong option.
Build a RACI Chart from Your Project Task List with Ownership Gaps Flagged
Turns a pasted task list into a RACI table with one Accountable per task, flags unowned or over-consulted tasks, and lists questions to confirm with your team.