Create a line graph of quanitity of values
 

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!

Create a line graph of quanitity of values
 

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!