Graphing frequency of a column of numbers
 

I'm having difficulty with this, I wonder if someone could help me with it?

I have a column of 80 numbers and I'm trying to graph out how many of each
number there are. The numbers will change over time. I've included an
abbreviated list below to illustrate.

0
0
0
0
<snip
0
0
1
1
1
<snip
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31

--
Ray Rogers

Graphing frequency of a column of numbers
 

Hi Ray,

One way;
With your numbers in column A.
Put zero in B1 and drag down holding down control as far as is needed.
Then in C1 put =COUNTIF(A$1:A$80,B1) and drag down as far as
the end of column B.
Aternatively use =COUNTIF(A:A,B1) for more flexibility.

This will show the frequency of each number used and zero
for any number not used in column A.

If you don't want the unused numbers to show you could try a similar
approach using advanced filter first.

HTH
Martin


"Ray Rogers" wrote in message
...
I'm having difficulty with this, I wonder if someone could help me with
it?

I have a column of 80 numbers and I'm trying to graph out how many of each
number there are. The numbers will change over time. I've included an
abbreviated list below to illustrate.

0
0
0
0
<snip
0
0
1
1
1
<snip
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31

--
Ray Rogers

Graphing frequency of a column of numbers
 

Thank you Gus, that's a good starting point for me. I'll play around with it
and see if it's what I want.
--
Ray

--
Ray Rogers
"Gus" wrote in message
...
Hi Ray,

One way;
With your numbers in column A.
Put zero in B1 and drag down holding down control as far as is needed.
Then in C1 put =COUNTIF(A$1:A$80,B1) and drag down as far as
the end of column B.
Aternatively use =COUNTIF(A:A,B1) for more flexibility.

This will show the frequency of each number used and zero
for any number not used in column A.

If you don't want the unused numbers to show you could try a similar
approach using advanced filter first.

HTH
Martin


"Ray Rogers" wrote in message
...
I'm having difficulty with this, I wonder if someone could help me with
it?

I have a column of 80 numbers and I'm trying to graph out how many of
each number there are. The numbers will change over time. I've included
an abbreviated list below to illustrate.

0
0
0
0
<snip
0
0
1
1
1
<snip
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31

--
Ray Rogers

Graphing frequency of a column of numbers
 

Ray

Check out help on the FREQUENCY function and/or Histograms

Analysis Toolpak add-in must be loaded to use the Histogram under ToolsData
Analysis.


Gord Dibben MS Excel MVP

On Sat, 19 May 2007 01:43:10 -0400, "Ray Rogers" wrote:

I'm having difficulty with this, I wonder if someone could help me with it?

I have a column of 80 numbers and I'm trying to graph out how many of each
number there are. The numbers will change over time. I've included an
abbreviated list below to illustrate.

0
0
0
0
<snip
0
0
1
1
1
<snip
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31

Graphing frequency of a column of numbers
 

Thanks Gord, this group is grrrrrrrreat.
--
Ray Rogers


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ray

Check out help on the FREQUENCY function and/or Histograms

Analysis Toolpak add-in must be loaded to use the Histogram under
ToolsData
Analysis.


Gord Dibben MS Excel MVP

On Sat, 19 May 2007 01:43:10 -0400, "Ray Rogers" wrote:

I'm having difficulty with this, I wonder if someone could help me with
it?

I have a column of 80 numbers and I'm trying to graph out how many of each
number there are. The numbers will change over time. I've included an
abbreviated list below to illustrate.

0
0
0
0
<snip
0
0
1
1
1
<snip
1
1
2
2
3
3
3
4
4
6
7
7
12
20
23
24
29
31