How to plot the distribution of quantities?

Question

infographics

Tell me, there is a list of values ​​​​of the form:

1
2
1
5
6
3
2
...

It is necessary to build a distribution curve for these values, I suspect that the easiest way to do this is in Excel, but how?

Answer 1

We asked, we answer:
if we have values ​​​​in column A, then we drive the formula =COUNTIF($A$1:$A$9;A1) into column B and stretch it over all values, it goes through all the values ​​​​and displays a count in front of them -in values. Then we sort the received data and remove duplicate rows, as a result we have two columns: value, number of occurrences. And already on these two data we build a graph.