Do you mean you just want to show totals for each town? Put labels in
the row above the data, like "Zip", "City", and "No." Select the data,
and make a pivot table (Data Menu). Drag the City field to the Row area
and the No. field to the Data area. Excel automatically fills the data
column with Sum of No. The pivot table looks like this:

Sum of No   
city         Total
Alpharetta     1
Atlanta        7
Austell        1
Birmingham     1
Bowdon         1
Conyers        1
Danville       1
Loganville     1
Marietta       2
Milwaukee      1
Newnan         1
Norcross       1
Roswell        1
Stone Mountain 1
Tampa          1
Tucker         1
Washington     1
Grand Total   24

Make a pivot chart, then use Chart Type from the Chart menu to turn it
into a Pie chart. Better yet, make a real chart: Select a cell away from
the pivot table and start the chart wizard. Choose a Pie in step 1, and
in step 2, click on the Series tab, and select the range with the city
names for X and the sums as Y.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______