Hi, I know this is simple but I haven't been on Excel in a while and cannot work it out!

I have a spreadsheet (using Excel 2007, Vista) with a lot of text (nominal data?). One column is a list of 8 animals, so it either displays 'cattle' sheep' 'pig' etc, in different quantities; e.g. there are about 1000 cattle, 800 sheep, 50 pig..

I want to produce a chart that shows the relative abundance of each animal. I tried highlighting the relevant column and then going to the chart (I have mostly been trying a pie chart) but I am producing no graph, and I think the data is being read as the chart title.

Can anyone suggest the appropriate solution?!

Oh and how can I tell if I am working in a pivot table or not?! Awful I know..

THANKS