Mike,
Yes, when I gave a quick try with the histogram before I posted my reply,
it refused to continue because the column title was included in the selection.

A pivot table is probably the quickest way to get an item count from a single
column list. It's frankly amazing.
Regards,
Jim Cone


"Mike Middleton"

wrote in message
...
Jim -
Unfortunately, as I recall, the Pareto option of the Histogram tool is of
very limited value because, once again as I recall, it requires numeric
data. It would be more useful for most purposes if it could work on a list
of text values. So, COUNTIF could be a useful workaround if the data are
text values; then, sort by counts, and construct a Column chart type.

- Mike
www.mikemiddleton.com

"Jim Cone" wrote in message
...
ES,

Possibly they meant...A Pareto diagram (chart)
From a Tushar Mehta posting...
A Pareto chart is a column chart of data sorted in descending order.
To have XL do the work, check the 'Histogram' capability in the Analysis
ToolPak...
Tools | Add-Ins | Analysis ToolPak
then...
Tools | Data Analysis... | Histogram.
Jim Cone
San Francisco, USA


<Excel
wrote in message
...
It was suggested that a workbook that I use be sorted using a prato
search. I cannot find anything on this. Could anyone help?