Aug 22 2022 04:57 AM - edited Aug 22 2022 05:05 AM
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?
Aug 22 2022 05:54 AM
@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