Forum Discussion
bar chart with ranges
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 ...
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