Merged data in Excel histogram

  • Thread starter Thread starter Katherine001
  • Start date Start date
K

Katherine001

I have a column of numbers and want to make a histogram showing the frequency
of each number. There are 49 different numbers. First I made 49 bins, then
50. In both cases, the frequency of 1s and 2s were merged into one column.
So, in other words, the histogram column for the 1s and the 2s is added
together.
What do you think the problem is ?
Thank you for help.
Katherine
 
Easier to just use COUNTIF in this instance
Assuming your source data is running in A1 down
In B1: =ROWS($1:1)
In C1: =COUNTIF(A:A,B1)
Copy B1:C1 down to C49
Col B returns the nums 1 - 49,
col C returns the corresponding counts (ie frequency) of each num within col
A
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top