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/ChartsH...idateData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"a0xbjzz" wrote in message
...
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!