How can I create a bar graph from cell columns with multiple comma-separated values? (data exported from survey with multiple selectable answers)

Desktop editors
,
1

Hi everyone!

I created a survey on a form website, and one of my questions allows for multi-select answers. In the export of the survey results, these multi-select answers are shows like this:

option a,option b, option f

I would like to know how to translate these results into a bar chart, so that I can know the count of each individual option.

It’s a similar question to this one, found on the Google Docs forum, except the solution doesn’t work in OnlyOffice.

Here’s a sample of what my data looks like:

id Which days + timesdo you prefer:
lMlw1 Thursdays evenings,Fridays evenings
9LoZz Monday evenings,Thursdays evenings,Saturday evenings,Sunday afternoons
gQO8G Thursdays evenings,Fridays evenings

OS version: Win10
App version: 9.4.0.129
Downloaded from: ONLYOFFICE website

2

Hi @candide,

The chart counts whole cell values, so "option a,option b" is treated as one answer. You need a small helper table first, then chart that.

  1. In a free column, list each option once (Thursdays evenings, Fridays evenings, Monday evenings, …).
  2. Next to each, count rows containing it with COUNTIF + wildcards. If answers are in B and the option list starts at D2:
=COUNTIF(B:B, "*"&D2&"*")

Drag it down.
3. Select the option + count table and go to Insert → Chart → Bar.

COUNTIF reference: COUNTIF function - ONLYOFFICE