Dear sir,
The easiest way seems to make a new table with formulas, selecting only the right data and making a chart over it.
Otherwise, if your data fits in a simple vertical table, make a pivot table and you have some filters like “10 highest values” or “values superior to 47”.
Last possibility, I can make a table with your items sorted by most frequent item, and stop at the point that you want, and create a bar chart over this new data.
If you have Excel version >2016, there is a new functionality that makes easy bargraphs from random data.
Text me for any needs and see my bio for the time I need to handle specific tasks.
1- Experience Excel : since 2004 both VBA and Formulas. I can make very complex formulas with multi conditions and text search applied on big ranges of data.
Example a formula to find the minimum value in column A, when a specific text exists in column B, other conditions in column C, and make operations on it in a single cell.
I know VBA, Java, C++, Python, JavaScript. In 2008 I was already working on a program of 70 000 lines of code in C++ that calculated the braking distance of A320 airplanes.
2- In Python : Last week I used the deep learning recommendation tool from Facebook (DLRN) and applied it to 30 000 lines of my company data, to select a suggestion of products for each client.
3- Academics : I graduated a Master in computer science and mechanical engineering from the top French Engineering school and this can be publicly verified.