School Nut -

The Analysis ToolPak add-in is available with Excel. If it is installed in
Excel 2007, the Data Analysis item appears on the Data ribbon. If not, run
setup to install it from the Office/Excel disk.

However, the Pareto feature of the Analysis ToolPak's Histogram tool is not
very useful because the raw data for the input range must be numeric. Raw
data for a Pareto chart is often text descriptions of causes of defects, and
the Histogram tool will not count the occurrences of non-numeric data.

Instead, you can use the COUNTIF worksheet function to obtain frequencies
for text data. Then you can construct a Column chart (vertical bars).

Or, you can use an Excel template. Use Google to search for "excel pareto
chart" (without the quotes).

- Mike

http://www.MikeMiddleton.com


"School Nut" School wrote in message
...
I'm trying to find the Data Analysis Tool Add-In for Excel 2007. Is this
a
software you need to purchase?

I already have Datalysis, MegaStat, etc.

This one is to do Pareto charts.