First, off I would like to say that I'm glad to be here and will try to help as much as I can and hopefully do a lot reading and learn.

My questions is, if you have this:

Business1
Business1
Business1
Business1
Business2
Business2
Business3

I need a formula/column chart that will show on the bottom (x) axis business 1,2,3, and y (axis) how many times it was listed.

business1/listed 4 times.
business2/listed 2 times.
business3/listed 1 time.