Chart Text columns

[Guest]

Is it possible to make a pie chart with text only in Excel columns. Example:
column with different city names and then create a chart that compiles the
percentage of cells with each of the different city names?

Thanks in advance....
@

 

[Frank Kabel]

Hi
you have to create a list of the frequency of each 'text' first on your
own
You could use for example a pivot table to create such a list. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm