Forum Discussion
Solved
Excel
How can I create a table in excel where the x axis has columns for a range of values? For example a column for the number of participants with a score of 1-10 another one for 11-20 and so on, with th...
You might use the FREQUENCY function. See the attached sample workbook.
Thank you for the reply. Maybe I used the wrong terminology here. I meant a column (or pillar) diagramm, where on the x axis you can find 0-10, 11-20 and so on and on the y axis the number of people that achieved that score.
You might use the FREQUENCY function. See the attached sample workbook.
- Thank you! That was what I was looking for!