I think the easiest way to get what you want is by using countif
Let's say that your city names are in the D column,
use some blank cells to hold this formula
=COUNTIF(D:D,"New York")
=COUNTIF(D:D,"Los Angeles")
etc.
now create a pie chart with these cells as the data series. I think
this is what you are looking for.