How can I display survey results in excel?

I%26#039;m looking to put about 150 similar answers into a pie chart. Currently, the answers are written by me, in excel, and I want to find a way to have the same text (like: %26quot;No help needed%26quot;) displayed as a fraction of a pie (%26quot;No help needed: 35% of surveys). The snag is, I%26#039;m not using numbers with the answers right now. Any ideas?|||create a couple of formulas...





=COUNTIF(A1:A150,%26quot;no help needed%26quot;)


=COUNTIF(A1:A150,%26quot;some help needed%26quot;)


=COUNTIF(A1:A150,%26quot;lots of help needed%26quot;)





then, select those 3 cells and you%26#039;ll have a count.


have the label (no help needed, etc) on the LEFT of the value





e.g.


no help needed | 10





then you can make the pie chart and include the data label





edit: email me if you need help.