bar chart with ranges

Question

I am trying to create a bar chart for some data, say for example:
1
1

2
2
3
4

I want to create a bar graph so each bar shows the frequency of a range. For example, the frequency of a value in my data set that is between 1 and 3, is 5. So there would be a bar that goes up to 5 on the y-axis. The next bar would go up to 2 on the y-axis since the range would be from 4 to 5.

Could someone help me realize this?

mtarler · Answer

CrewReprs&nbsp;You frequency ranges seem to be customized (not equally divided or must be specific ranges) so I recommend you create your own table.&nbsp; Create a column for the bins like 3, 5, 8, ... and then you can use the FREQUENCY() to then find the bin totals:1&nbsp;3=FREQUENCY($A$1:$A$7,$C$1:$C$3)&nbsp;&nbsp;1&nbsp;5&nbsp;2&nbsp;8&nbsp;2&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;Then you can easily add a bar chart using that new table&nbsp;

Forum Discussion

bar chart with ranges

1 Reply

Resources

1	3	=FREQUENCY($A$1:$A$7,$C$1:$C$3)
1	5
2	8
2
3
4
5