I've been using Excel for years and am going absolutely nuts trying to make a simple pie chart.

Let's say I have a text column

Apple
Orange
Cherry
Cherry
Apple

From the above I want to create a simple chart that show 3 slices and the percentages. How is this done?

Many thanks!
ps. Excel 2010