3

I used a survey to collect data about people's opinion. The question is answered using a check-box (Yes/No). I would like to visualize the results using charts.

How can I do that using one column?

All the examples that I have seen are related to graphs using two columns. For example:

col A   
 No      
 Yes     
 Yes  

Pie chart : 66% YES - 33% NO

2 Answers 2

2

I believe there is no way to create a chart from a single column, you have to count the occurrences of the words first. Use the COUNTIF-function.

Here's an example: Single Column Pie Chart

If you look at the two cells where the occurrences of the words is counted you can see two ways. Either searching for the content of a referenced cell or a static string.

3
  • Great! Glad I could help. :) Mar 17, 2014 at 22:41
  • Only more thing, Can I tweak this to make it contain instead of equality to overcome problems of blank and ascii characters =COUNTIF(E:E," contains F3"&F2) Mar 18, 2014 at 0:02
  • Yes, I've updated my example spreadsheet. Use the * operator. It means "anything", so the COUNTIF counts the cell if it contains "anything and 'yes' and anything" (if the cell contains 'yes'). Mar 18, 2014 at 0:08
3

Just select A1:A4, Insert > Chart...:

WA58373 example

1
  • Boom. Too easy.
    – Matt West
    Jan 14, 2021 at 18:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.