I am completely new to VBA and my only other coding experience has been with Python.

Situation: We are doing a "working meeting" where we are going to give scores to devices and want to chose which ones are best.
I want to make a dynamic bar graph that will display the spread of the scores. Ex.. 2 objects got a score of 10, 1 got a score of 9.
I will not know what the range of scores will be until we do it at the meeting. I was hoping to use a command button to generate it.

I was thinking I would use VBA to first generate a list of numbers from 0 to the highest score by referencing a cell with the highest score.
Then I could generate a COUNTIF function that would determine the number of times each number appeared.
Lastly, I could use those two columns of numbers and count to make a chart.

Any help at all would be appreciated on even how to begin doing this.
EDIT: I have tried making variables, using For loops, etc. but I'm thinking there must be a more efficient way.

Thanks!