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.
@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:
Then you can easily add a bar chart using that new table