How can I create a bar graph from cell columns with multiple comma-separated values? (data exported from survey with multiple selectable answers) | Buobe
How can I create a bar graph from cell columns with multiple comma-separated values? (data exported from survey with multiple selectable answers)
Buobe IA context · why it matters
Comma-separated values in multi-select answers — You need to split these values into individual entries for accurate counting and graphing.
Translation into a bar chart — Use data cleaning tools or scripts to separate each option, then plot the frequency of each choice.
Fique de olho:
Develop a script to parse comma-separated values before creating your bar graph.