Create a line graph of quanitity of values

[a0xbjzz]

Hi, I am terrible with excel so I really appreciate the suggestions, in
advance!!

I am using excel to create a graph showing the ages of my employees. I'd
like to show the demographic.... maybe a bar graph? Probably putting the
quantity of employees on the Y axis and the age ranges on the X axis. How do
I go about this? Can I make this from a selection of just ages, or do I need
to create a new table showing the information I want to graph?

Thanks!

 

[Jon Peltier]

You need to use an intermediate table. Charts only show values, they don't
calculate values. But you have this great worksheet full of calculation
capabilities.

I've written up a quick tutorial showing how to prepare a list of items for
charting of their frequencies.
http://peltiertech.com/Excel/ChartsHowTo/ConsolidateData.html

- Jon