Pick the Right Chart Type for Your Data and Design It Cleanly
Get one recommended chart for your data, with an insight-style title, labeled axes, a single highlight color, a list of clutter to remove and build steps.
You getRecommended chart and why, why not the runner-up and title and subtitle
Prompt
You are a data visualization designer who makes charts for business slides and reports.
Help me pick the right chart for my data and spec it so I can build it cleanly. First ask me these questions in one message, then wait for my answers:
1. What is the data? Paste a sample or describe the columns and rough values.
2. What must the chart show: change over time, ranking, part-to-whole, distribution, or a relationship between two measures?
3. What one point should the audience take away, and where will they see it (slide, report, dashboard)?
Rules:
- Recommend exactly one chart type, and say in one sentence why the runner-up is worse for this data.
- Write the title as the insight: a full sentence with a number, not a label like "Sales by Region".
- Use one highlight color for the data that carries the message; everything else in gray.
- Name at least four specific elements to remove or mute.
- Every axis label includes units; value axes on bar or column charts start at zero.
Output format:
1. Recommended chart and why
2. Why not the runner-up
3. Title and subtitle
4. Axes: labels, units, scale
5. Colors: highlight and base, with hex codes
6. Clutter to remove (bullets)
7. Build steps (5-7, numbered)
End with one line on any assumption you made or a missing detail that could change the recommendation.Example output
Tips and common edits
Why this works
- Asking which comparison the data must show first ties the chart choice to the message, not to habit or software defaults.
- Forcing one chart plus a reason against the runner-up gives a decision, not a menu of options.
- Insight titles, one highlight color and a named clutter list turn vague 'make it clean' advice into checkable steps.
Use before building a chart for a slide or report. Have your data or a short description of its columns ready. Works in ChatGPT, Claude or Gemini; paste a small table sample for the most specific advice.
Common edits
- Name your tool (PowerPoint, Tableau, Google Sheets) so the build steps match its menus.
- Add your brand colors so the highlight and base hex codes fit your slide template.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Rewrite Text-Heavy Slides into Clear Headlines, Short Bullets and Visuals
Turns your pasted slide text into takeaway headlines, up to three short bullets, one specific visual per slide and speaker notes that keep the cut detail.
Build a Color Blindness Simulator That Previews a Palette on a Dashboard Card
A single HTML file that redraws a realistic dashboard card under protanopia, deuteranopia, tritanopia and grayscale and flags color pairs that become hard to tell apart.
Build an Investor Pitch Deck Structure from Your Startup Notes
Get a 10-12 slide investor deck outline built only from your notes, with a claim-style headline per slide and every evidence gap flagged instead of filled.
Critique a Slide Screenshot with Scored Areas and Five-Minute Fixes
Upload a slide or design screenshot and get separate scores for alignment, contrast, hierarchy, spacing and text density, plus ranked quick fixes.
Build an Analytics Dashboard with Sidebar, KPI Cards and SVG Charts in One HTML File
A responsive store analytics dashboard with a collapsible sidebar, four KPI cards with sparklines, and hand-drawn SVG line, donut and bar charts.
Turn Your Notes into a Slide-by-Slide Presentation Outline with Speaker Notes
Get a slide-by-slide outline in which each slide has one full-sentence takeaway headline, a minute budget, a suggested visual and speaker notes you can say aloud.
- Build a Button and Form Field States Reference Sheet in a Single HTML File
- Build a Drag-to-Arrange Brand Mood Board with Color, Texture and Type Tiles
- Build a Live Accessible Color Palette Builder with a WCAG Contrast Matrix
- Build a Modular Type Scale Specimen with Adjustable Ratio and Base Size
- Build a Responsive Three-Tier Pricing Section with Monthly/Yearly Toggle
- Build a SaaS Landing Page Hero with a CSS-Drawn Product Mockup