Mariam -

One method is to use a pivot table to count the occurrence of each text
string, sort by frequency, and then construct a column chart.

If you need more details, describe your data. Or, browse to google.com and
search for Excel Pareto Chart.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Mariam" wrote in message
...
how to get a pareto diagram in excel