pie chart

Hi all
For a stats paper I am writing I have collected data on budget, release period, gross and MPAA rating of movies from 2008. I have been trying to create a pie chart roughly like this
\1
which would show frequency of each mpaa rating over the ~106 movies I have. Unfortunately whenever I try to turn the MPAA rating column into a pie chart I get all kinds of problems. Usually all the data is turned into the title of the chart so I have a chart called 'MPAA RATING G G G G PG PG PG PG etc' and there is one slice on the pie chart for all 106 entries. I have tried turning my file into a csv, reformatting the field type, and adding each rating as a series but nothing has helped.

Attached is the excel file I am working with if anyone wants to look at it. Any help is appreciated.
Thanks in advance,
-christos

Please see the attched!!movies(1).xls