Forum Discussion
AggelosMarios
Apr 11, 2023Copper Contributor
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...
- Apr 12, 2023
You might use the FREQUENCY function. See the attached sample workbook.
AggelosMarios
Apr 11, 2023Copper Contributor
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.
HansVogelaar
Apr 12, 2023MVP
You might use the FREQUENCY function. See the attached sample workbook.
- AggelosMariosApr 12, 2023Copper ContributorThank you! That was what I was looking for!