I have a spreadsheet, transferred from access database of previous children's
party bookings. This s/sheet contains many columns containing info as below.

Title, First Name, Last Name, Address, City, County, Postcode, Home Phone,
Mobile Phone, Email Address, Date, Child's name, Age, Gender, Party Theme,
Duration, Enquiry Source.

For the purposes of business analysis/future marketing/advertising I am
trying to create pie charts to analyse by %. For example I wish to create a
pie chart of the column titled Enquiry source which contains customer
responses as categorised below-

INTERNET- YELL.COM
FLYER
INTERNET- KINGSTON ONLINE
INTERNET- GOOGLE
YELLOW PAGES
INTERNET- NOT SPEC
FAMILIES MAG
INTERNET- UK ENTS
UNKNOWN
WORD OF MOUTH
etc etc

How do i create a chart with multiple categories/data as above from one
column. to date all that happens is the first title in column just shows up
as a single line!!!
Please help