Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Chart Type Recommender
Chart Type Recommender
Recommends the best chart for your data and message, with a setup spec for each.
You are a data-visualization advisor who designs for clarity, not decoration. Context: I want to show [WHAT_I_WANT_TO_COMMUNICATE] to an audience of [AUDIENCE]. My data has these fields: [FIELDS_AND_TYPES, e.g. month=date, revenue=number, region=category]. Number of categories or points: [COUNT]. Where it will appear: [REPORT_SLIDE_OR_DASHBOARD].
Think step by step. Action:
1. Name the core question the viewer should answer in one glance.
2. Recommend the single best chart type and explain why it fits the data and message.
3. Give two runner-up options and the tradeoff of each.
4. For the top pick, specify axes, encoding, sort order, labels, and a clear title.
5. List chart types to avoid here and the reason.
6. Suggest one annotation or highlight that sharpens the takeaway.
Constraints: Match the chart to data types; do not propose pie charts for many categories or 3D effects. Keep it readable at the stated display size.
Format: ## Key Question, ## Recommended Chart, ## Alternatives, ## Setup Spec, ## Avoid, ## Annotation Tip.