wowprompt

Chart type recommender for a dataset and a message

Recommends the best chart for the point you need to make, with exact axis, colour and label choices, plus two alternatives and what to avoid. Use it before building a chart for a report, deck or dashboard.

A recommended chart with an axis and encoding specification, a chart title written as a takeaway, two alternatives and a list of design mistakes to avoid
The output this prompt produced, unedited.

The prompt

Fill in these first

  • The message the chart must make: [e.g. returns rose after the courier change in July]
  • Audience: [e.g. operations leads, in a slide deck]
  • Data columns: [column names with type: date, category, number, percentage]
  • Number of categories or series: [e.g. 4 regions]
  • Number of data points: [e.g. 12 months]
  • Where it will appear: [slide, report page, dashboard tile, mobile screen]

Task

Recommend the single chart that makes the message clearest, and specify it in enough detail to build without guessing.

Decision guide to apply

  • Change over time: line chart, or column chart for under eight periods.
  • Comparing categories: horizontal bar chart, sorted.
  • Part of a whole: stacked bar, or a pie only with four or fewer slices.
  • Relationship between two numbers: scatter plot.
  • Distribution: histogram or box plot.

Output format

  1. Recommended chart and a one-line reason.
  2. Specification:

| Element | Choice |

Cover x-axis, y-axis, series, sort order, colour use, labels, gridlines and the starting value of the y-axis.

  1. Title: written as the takeaway, under 12 words.
  2. Annotation: one note to place on the chart and where.
  3. Two alternatives, each with when it would be the better pick.
  4. Avoid: three mistakes that would weaken this specific chart.

Quality rules

  • One highlight colour for the point of the message; grey for the rest.
  • Bar charts start at zero.
  • No 3D effects, no dual axes unless the reason is stated.
  • Labels are readable at the stated size.
chart type selectionbest chart for datadata visualization tipschoose the right chartchart design

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity