How do I *automatically* create a frequency histogram of individual alphanumeric values in Excel?

Question

Basically, I want to do a histogram count of the number of NSF Fellowships awarded by undergraduate institution (which is Column C). How do I do this from this data table? (taken from https://www.fastlane.nsf.gov/grfp/AwardeeList.do?method=sort&page=25 )

I'd like to do it completely automatically - without having to manually insert the names of each and every university. A short Excel workflow is fine.

Answer 1

if i understand correctly, you want to insert a pivot table + column chart with data from column C as both rows and data (using count) ...