axis problems in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column titled "age" in my excel spreadsheet. There are 29 values
entered in total, and several of them are the same. EG four people age 35.
The total range is from 18 to 39. I want a simple column chart with age on
the x axis (from 18 to 39) and number of people on the y axis (0 to 5). But
i cannot work out how to do it. Sorry if this is an easy one. Excel only
seems to allow me to have age on the y axis, with the 29 values represented
by columns.

any help would be appreciated

denise
 
Denise

You need to group the age data by frequency.

In say column A wite ages 18 to 39 and then in column B write how many
people are of that age. For example...

18 1
19 1
20 2
21 1
22 3
23 4
25 1
26 5
27 2

etc...

Now just chart that as a column chart. This should work. The way you are
trying to do it, Excel will not group the people of the same age together and
will terat them as discrete data points unless you tell Excel otherwise...

If you have any further difficultioes, do write back and I will assist more...

Regards


Alex
 
Check XL's histogram capability (Tools | Data Analysis... | Histogram)
or the FREQUENCY function. Alternatively, create a PivotTable (Data |
PivotTable and PivotChart report...). Specify the Age field as the row
field and the data field. If XL sets the data field to 'Sum of Age'
doubleclick the name and in the resulting dialog box change the Sum to
Count.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top