Re: Create a line graph of quanitity of values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"a0xbjzz" <a0xbjzz@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CD545303-716D-478B-B65A-09CB27832BE6@xxxxxxxxxxxxxxxx
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!


.

Relevant Pages

  • Re: Variables on X & Y Axis
    ... along the axis, or because the axis scale changes? ... use on of these free tools to add the labels in the first column to ... Employees are are graded in two broad areas, ... I have tried using a Scatter Graph, but the postion of the employee on the ...
    (microsoft.public.excel.charting)
  • X axis
    ... how do i change the verbiage of the "category X axis"? ... it's showing 1,2,3 etc, i want it to show months. ... be gentle w/me...don't understand many of the terms used in a graph. ...
    (microsoft.public.excel.charting)
  • X Axis to Scale
    ... I am charting the following with a line graph. ... I have the percentages on the x axis but they are showing up as four ...
    (microsoft.public.excel.charting)
  • x axis not showing correct values
    ... i have dates on my x axis, but for this graph i am not using all of it, e.g. ... showing up correctly. ... Prev by Date: ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)