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

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

At a glanceBuilding the resolution time line chartSeven build steps from the example's recommended line chart
  1. Insert line chartStep 1Use the Month and Median Hours columns
  2. Split the seriesStep 2Jan–Jun and Jun–Dec, overlapping at June
  3. Color the segmentsStep 3Gray #A6A6A6 before, blue #1F5AA6 after, 2.5 pt
  4. Fix the y-axisStep 40–35, major units of 10; drop gridlines and border
  5. Mark JuneStep 5Dashed line labeled New triage process
  6. Add key data labelsStep 6Only Jan (31), May (30) and Dec (14)
  7. Finish titlesStep 7Delete legend, add insight title and subtitle

Example for: a support team lead showing 12 months of median ticket resolution time, with a new triage process starting in June, for a quarterly review slide.

1. Recommended chart and why

Line chart. You are showing change over 12 consecutive months, and a line makes the drop after June read as one continuous trend instead of 12 separate bars.

2. Why not the runner-up

A column chart would work, but 12 columns make the eye compare individual months rather than see the before/after shift.

3. Title and subtitle
  • Title: Median resolution time fell from 31 to 14 hours after the June triage change
  • Subtitle: Median hours to resolve a support ticket, Jan–Dec, all channels
4. Axes
AxisLabelUnitsScale
XMonthJan–DecOne tick per month, 3-letter abbreviations
YMedian resolution timeHours0 to 35, ticks every 10

A line chart does not strictly need a zero baseline, but starting at 0 here keeps the drop honest.

5. Colors
RoleColorHex
Highlight: Jun–Dec segmentDeep blue#1F5AA6
Base: Jan–May segmentMid gray#A6A6A6
Annotation textDark gray#404040
6. Clutter to remove
  • Horizontal gridlines (keep only a light baseline at 0)
  • Legend: label the line directly with "After triage change"
  • Data markers on every point; keep only Jan, May and Dec values
  • Chart border and background fill
  • Decimals on the y-axis (31.0 becomes 31)
  • Default chart title from the software
7. Build steps
  1. Insert a line chart from the Month and Median Hours columns.
  2. Split the series into two columns (Jan–Jun and Jun–Dec, overlapping at June) so each can be colored separately.
  3. Set Jan–Jun to #A6A6A6 and Jun–Dec to #1F5AA6, line width 2.5 pt.
  4. Fix the y-axis at 0–35 with major units of 10; delete gridlines and border.
  5. Add a thin vertical dashed line at June with the label "New triage process".
  6. Add data labels only at Jan (31), May (30) and Dec (14).
  7. Delete the legend and type the insight title and subtitle in a text box above the chart.

Assumption: monthly medians were calculated the same way all year; if ticket volume changed sharply in June, add a note so the drop is not misread.

Written by AI from this prompt. Your results will vary.

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
How prompts are written and checked

Did this prompt work?

Keep exploring

More in Design