Guides › Research & News

Pick the right chart for every finding

A chart recommendation for each finding, with a clear title that says the point and a note on what to avoid.

Market research analystBeginner10 minAI assistantGoogle Sheets
Open the interactive guideBrowse all guides

When to use it

When building slides or a report from data

Step by step

  1. List what you want to show

    Write each finding as one line, along with the data behind it (for example 'share of buyers by age group, 5 groups').

  2. Ask for chart advice

    Paste this prompt into your AI assistant.

    Prompt to copyI'm presenting research findings to [audience]. For each finding below, recommend the best chart type and explain why in one line. Also give: a chart title that states the takeaway (not just the topic), what goes on each axis, what to highlight in colour, and one common mistake to avoid with this data. Present as a table. Findings and data: [paste list]
  3. Build the charts

    Create each chart in Google Sheets or Excel using the advice, and use the takeaway as the chart title.

What you get

Finding: satisfaction by region (6 regions). Chart: horizontal bar, sorted high to low. Title: 'The North West is the only region below target.' Highlight: North West bar in orange, the rest grey. Avoid: a pie chart, as six close values are hard to compare.

Tips

More Research & News guides