Hi all,

i've got this worksheet going. the data is a collection of stats from a
market research. its got name, company, address questions and answers.
some are simple answers like yes no, others are multiple choices.

so basically i want to draw up charts for this. but i figure i can only
do this with numerical data not textual data. is there a formula or way
around it?

i am absolutely clueless how to do it.

so if it works out i want a pie chart or bar chart that represents the
question and the percentages of how the answers were received. e.g. for
a sample question of what kind of pets do you have... i want a chart to
represent the one question "how many pets do you have" and the data in
the chart to reflect the answers collected...

soooo... if 5 answered dog, and 7 answered cats. i want the chart to
show this as if its drawn up a chart from numerical data to begin with.
see below for further detail...

--------------------------------

Question: what is your fav animal?
dog
cat
dog
dog
dog
cat
cat
monkey
elephant
...
..
..

i want the above data to be graphed into a nice pie or bar chart
representing the percentages shown proportionally...

IS THIS EVEN POSSIBLE???

---------------------------------------------------------

cheers.


--
TheDevil
------------------------------------------------------------------------
TheDevil's Profile: http://www.excelforum.com/member.php...o&userid=33708
View this thread: http://www.excelforum.com/showthread...hreadid=534879