If I only hava a long list of names e.g like this;

Andy
Andy
Carol
Carol
Carol
Robert
Robert
Robert
Robert
and so on

I want to make a chart that shows both the names and how many times
the name are occuring in the list.

How can I do this with just a long list of names in Excel?

Thanks
/Chris