chartcamel Make a chart

Charting survey results

Most survey charts are one of three kinds: one answer per person, several answers per person, or a rating scale. Each needs a slightly different chart.

1. Count the answers first

ChartCamel charts counts, not raw responses. In your spreadsheet, make a column of the possible answers and a column of how many people chose each (in Google Sheets or Excel, =COUNTIF(range, "Instagram")). Paste those two columns.

2. One answer per person: a ranking chart

Sort the answers largest to smallest, then use the ranking chart (horizontal bars). Long answer text fits beside the bars, and the order does the explaining. The panel gives each answer's share of the total and what the top three add up to.

3. "Check all that apply": bars, never a pie

When people could pick several answers, the counts add up to more than the number of respondents, so there is no whole to slice. Use bars or a ranking chart and say in the title how many people answered, for example "Features used (84 respondents)".

4. A 1-to-5 scale

Paste the scale in order (1 to 5, or Strongly disagree to Strongly agree) with the count for each, and use a bar chart. The shape shows whether answers lean one way or split into two camps, which an average hides. A pie of a scale loses the order. If you need one number, the panel's average and median are there; report both when they differ.

5. "Other" and small groups

Keep "Other" as its own row at the bottom. Don't drop it: the panel's percentages are shares of the total you paste, and removing a row makes every other share too high. If you have many answers with one or two votes, add them into "Other" and say so under the chart.

6. Write the sentence

Copy the explanation and trim it: "64 of 185 people (35%) heard about us from a friend or family member; the top three sources account for 82% of answers." That's the caption. Mention the number of respondents and the date you ran the survey.

Open the survey template