I have a list of words, one in each cell, such as Jimmy, Joe, Sam, Joe, Jimmy, Jimmy. I want to make a bar graph showing the frequency of each name. How can I do this? Can I only make graphs with number data?

The data from my example should yield Jimmy: 3, Joe: 2, Sam: 1, and create a graph illustrating such.

Also, is there a way to toggle case sensitivity?

Please don't ask me to count them by hand or to use a find/replace to count them. I have over 26,000 data and many unique entries.

Thanks!
Multi