Data & analytics

Chart recommendation prompt

A copy-and-paste prompt for ChatGPT, Claude or Gemini that gets a professional chart recommendation on the first try, plus the cheapest model that does it well.

What most people type

what chart should I use to show monthly revenue for 3 product lines over 2 years

It works, but the AI has to guess your audience and goal and charting tool, so the first answer usually needs another round. The version below asks for exactly what a professional would deliver.

The better prompt

Recommend the best chart type to show monthly revenue for 3 product lines over 2 years (24 months).

Context: [audience and what they need to decide or see, e.g. trends, seasonality, comparison between lines, share of total]. [Tool used to build the chart, if any].

Give:
- One primary recommendation, with 2-3 lines on why it fits this data and purpose.
- One or two alternatives and when each would be the better choice.
- Chart types to avoid for this data, with a short reason each.
- Key design tips: how to handle 3 series, axis and scale, colors and labels, and how to make year-over-year comparison easy.

Keep it practical and under 300 words. Don't invent data.

Replace the [brackets] with your details before you send it: Tool used to build the chart, if any.

Why this version works

  • Added audience and purpose placeholders. The best chart depends on what the viewer must see.
  • Requested primary pick, alternatives, and chart types to avoid. Gives a decision-ready answer on the first try.
  • Added design tips for 3 series. Covers year-over-year comparison and readability.
  • Set a 300-word limit. Prevents a rambling chart survey.

What a professional chart recommendation prompt covers

  • Asks for a recommendation with a short reason
  • Short

Best AI model for this prompt

This is a light task: common data-viz advice; a small model answers reliably with clear purpose. You don't need the most expensive model. The cheapest model at each company that handles it well:

CompanyModelPer usePer 1,000 uses
AnthropicClaude Haiku 5.5cheapest$0.00022$0.22
OpenAIGPT-6 Luna$0.00022$0.22
GoogleGemini 3.1 Flash-Lite$0.00064$0.64

Pay-per-use list prices for this prompt and its expected answer (about 400 tokens). On a monthly chat plan, the same choice shows up as more messages before you hit your limit. See today's AI prices.

Chart recommendation prompt for ChatGPT, Claude and Gemini (Data & analytics) · PromptSaver