Chart to show response to a question. One of answer 15 choices.

I know this will be simple but I can't figure it out. On a number of given
dates I ask how happy people are and get a number of responses between 1 and
15. I then need to plot the number of occurences of those individual respones
i.e. two people were 2, three people were 7 etc. I guess it might be a simple
X/Y but I just cannot fathom it out.

Any help would be greatly appreciated.

Regards, Nick.

Hi,

You need to create a summary table of possible responses and tally.

Assuming responses are in A1:A15

in B1:B5 are the value 1 to 5, which are the available responses.
in C1 use =COUNTIF($A$1:$A$15,B1)
copy down thru C5

Now create a column chart on B1:C5

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"PirateSam" wrote in message
...
I know this will be simple but I can't figure it out. On a number of given
dates I ask how happy people are and get a number of responses between 1
and
15. I then need to plot the number of occurences of those individual
respones
i.e. two people were 2, three people were 7 etc. I guess it might be a
simple
X/Y but I just cannot fathom it out.

Any help would be greatly appreciated.

Regards, Nick.

You first need to generate the data. I.e., create either a PivotTable with
Chart (seems a bit overkills for this scenario) or use a few COUNTIF formulas
to determine how many people gave a particular response on each day. Then
plot the formulated data.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PirateSam" wrote:

I know this will be simple but I can't figure it out. On a number of given
dates I ask how happy people are and get a number of responses between 1 and
15. I then need to plot the number of occurences of those individual respones
i.e. two people were 2, three people were 7 etc. I guess it might be a simple
X/Y but I just cannot fathom it out.

Any help would be greatly appreciated.

Regards, Nick.