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

[PirateSam]

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.

 

[Andy Pope]

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

 

[Luke M]

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.