y-AXIS

[Sam]

Hi,
I'm working on a neuroscience project and I data that looks like this:
0
0
0
0
0
0
0
0
0
0
1
1
1
1
1
........keeps going until
105

Basically, this data is in tha A column and it goes up to about 2217. The
numbers represent age at death.
I want to make a bar graph with the x-axis as "age at death" and the y-axis
as "number of those that died".
I'm sure there's an easy way of doing this as I only have one column of
data, but each time I try to make a graph, it does something that looks like
a cumulative graph.

HELP!!!!

Samantha Perera

 

[Del Cotter]

The numbers represent age at death. I want to make a bar graph with the
x-axis as "age at death" and the y-axis as "number of those that died".

Make a Pivot Table or Pivot Chart, using the single column. Be sure to
give it a name, like "Data", at the very top of the column

Data
0
0
1
1

Then have your table be "Count of Data" against "Data", and you will
have the distribution you seek.