Merged data in Excel histogram

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If any specific #s are present in range, show each in another cell 6
histogram from weighted data 4
Histogram Question 2
Histogram? 4
Histogram Plot 1
Histogram And Bin Size ? 1
Histogram tool 1
how to make a histogram with frequency 1

Top