Recent chats
ASKGEEZ Q&A GUIDETechnology & devices

How can I chart survey answers when respondents could select more than one option?

Quick answer

Count how many respondents selected each option, and chart those option totals—not a single, mutually exclusive tally. Label the values “selections per option” or “respondents selecting each option.” If you show percentages, name the denominator, such as all respondents who answered; percentages across options can add to more than 100% because one person may select several options [S1].

LET’S WORK THROUGH IT

The question, the details, the next step.

Question

I have a survey question where people could tick several answers. How should I prepare the results before making a chart?

Geez

Treat every answer option as its own count. For each option, count the respondents who selected it; a respondent who chose three options contributes once to each of those three option totals. For checkbox-style questions, raw counts by option are the appropriate starting point. These totals describe selections for each option, not separate, non-overlapping groups of respondents [S1].

Before charting, make a small summary table with one row per option and a clearly named count column. Keep the survey’s original response records available so you can check that the summary reflects the selections, especially if you clean or combine option labels. Don’t add the option counts and present that sum as the number of people: the same respondent may appear in multiple option totals.

Follow-up question

Could you show me what the counts and percentages might look like?

Geez

Suppose, as a hypothetical example, 20 people answered a survey question about preferred ways to receive updates. They could choose more than one option. After counting each option, your summary might be:

Email — 12 respondents selecting this option Text message — 9 respondents selecting this option Team meeting — 5 respondents selecting this option

If you choose all 20 respondents who answered as the percentage denominator, those values are 60%, 45%, and 25%. The percentages total 130%. That is not necessarily an error: a person can be counted in more than one option, so percentages across options can exceed 100% [S1]. State the denominator beside the chart or in its note so readers know what each percentage means.

For example, the chart title could be “Ways respondents receive updates (multiple selections allowed).” Label the horizontal axis “Respondents selecting each option” if showing counts. If showing percentages, write “Share of respondents who answered” and note the denominator is 20. Avoid a bare title such as “Share of responses,” which may leave readers unsure whether you mean people or selections.

Follow-up question

What if my charting tool shows a total or asks whether the percentages should add to 100%?

Geez

First decide what you want the chart to communicate. For an option-by-option view, keep each option’s count as a separate value and label it as an option selection or as respondents selecting that option. Don’t force those values into a 100% total if doing so would make the chart look like each person chose only one answer. Multiple-answer results can legitimately have percentages across options that add to more than 100% [S1].

If the tool displays a grand total, clarify what that total counts. In the example, 12 + 9 + 5 = 26 option selections, while 20 people answered. Those are different quantities. A total of 26 should be labeled “total option selections,” not “respondents.” If your tool’s labels or calculations are unclear, make the summary table yourself first and use it as the source for the chart. The cited guidance explains how to interpret multiple-answer results; it does not prescribe a specific charting application or its controls [S1].

Follow-up question

Can you give me a copyable setup and a quick check before I share the chart?

Geez

Use this template, replacing the brackets with your survey’s details:

Chart title: [Question topic] — multiple selections allowed Values: [count] respondents selecting each option Percentage denominator, if used: [number] respondents who answered Note: Respondents could select more than one option, so option counts or percentages may add to more than the number of respondents or 100%.

Then verify each option count against the response records and check that your labels distinguish people from selections. A useful final question is: could someone seeing only the chart tell what one bar or slice counts? If not, revise the title, axis label, or note before sharing.

A practical checklist

  • List every answer option and count respondents who selected it.

  • Keep option totals separate; do not present their sum as distinct respondents.

  • If showing percentages, state the denominator, such as respondents who answered.

  • Label counts as respondents selecting each option or as selections per option.

  • Add a note that respondents could choose more than one option.

  • Check that the title and labels explain exactly what each chart value represents.

A few more useful answers

Is it wrong if the percentages add up to more than 100%?

Not necessarily. When respondents can select multiple options, one person may contribute to several option percentages, so the percentages across options can exceed 100% [S1].

Should I label the chart’s total as the number of respondents?

Only if it actually counts distinct respondents. A sum of the option counts represents total option selections and can be greater than the number of people who answered.

Does this guidance depend on a particular charting program?

No. The key is how you count and label the results; the cited guidance addresses interpretation, not instructions for a particular charting application [S1].

Sources

References used for this guide.

  1. [S1] How to analyze multiple-answer questions — Google Surveys Help
    support.google.com · Checked

YOUR QUESTION. YOUR DETAILS.

Let’s work through your situation.

Get a tailored answer or help with your next task. Starts at $1, with a quote before you pay.

Ask your own question
← Back to Geez at Work