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.