bar chart with ranges

Occasional Contributor

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?

1 Reply

@CrewReprs You frequency ranges seem to be customized (not equally divided or must be specific ranges) so I recommend you create your own table.  Create a column for the bins like 3, 5, 8, ... and then you can use the FREQUENCY() to then find the bin totals:

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

 

Then you can easily add a bar chart using that new table