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

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.

| improve this answer | |
  • Great! Glad I could help. :) – Punchlinern Mar 17 '14 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) – user3378649 Mar 18 '14 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'). – Punchlinern Mar 18 '14 at 0:08
1

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

WA58373 example

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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