I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like:

Abrams

Abrams

Butler

Cromwell

Cromwell

Cromwell

Edison

Foster

Foster

Foster

Foster

Foster

Walters

...in Excel, can I make it create a pie chart that takes these values and creates a proportional pie cart by the weight of each name against the total number of entries? I could do all this manually, by adding the duplicates and doing the math and manually doing, well, all that work, but I was hoping there'd be an automatic way to have Excel do the consolidating-and-math bit. There are a *lot* of things in this survey like the above list, so it's be great to be able to repeat this for a number of questions and answers.