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.