Sandi -

You could use the Histogram tool of Excel's Analysis ToolPak, or you could
use my free Better Histogram add-in available from the Histogram page at
www.treeplan.com, perhaps with start, step, stop equal to 15,5,75.

Or, you could use worksheet functions like COUNTIF and FREQUENCY to obtain
frequencies, and then create a Column chart.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Sandi" wrote in message
...
I have been asked to show frequency using the responses to the question
"what
is your age?" The ages range as follows: Age
Question 1
27
34
21
41
53
61
24
26
37
30
40
65
20
21
45
37
58
38
40
69

Can someone please help me in quiding me in setting this up on a graph
with
Excel and how would I briefly explain my findings in a couple of
sentences?