Craig

Perfect job for a pivot table. The only difference I would make in this
scenario would be to keep the trips on one sheet and add a date column next
to each entry.

To create you basic pivot take the options DataPivot table and using your
whole data range place the town column onto the row field area and then add
it again to the value area and this should be set automatically to 'Count'.
From this you can now simply, from the pivot table toolbar, select the pivot
chart option to chart from this data

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Gigafreak" wrote in message
oups.com...
Hello Group

I am a new subscriber to the group and a fairly new Excel (2002) user.
What I would like to know is how can I count the number of occurences
of words in a column.

To explain what I mean I'll try and illustrate my worksheet and what I
am using it for.

In column G of each worksheet I have a list of places that have been
visited, this list is added to and each worksheet is a new month. The
list of place names may include place names and, of course duplicate
place names eg;

Bristol
Bath
Swindon
Exeter
Bristol
Cardiff
Newport
Bristol

What i would like to do is create in column H a result that shows the
number of times each place name occurs in that specific month. From
there I could probably work out how to create a chart to illustrate
the monthly/annual place visit statistcal reprosentation.
Any ideas comments would be greatly appriciated.

Craig