How to create pareto chart

[rOn]

In Excel, we use three party developer, for generate pareto chart. I have search on internet for pareto chart for OpenOffice.Org, but not found. Can help me?
_________________
rOn

[dfrench]

You can generate a Pareto chart directly in OOo calc using the standard charts.
Using the definition of a Pareto chart from sixsigma .. ttp://www.isixsigma.com/library/content/c010527a.asp

Construct your data as three columns Bin, Frequency and % with column labels
Select the range and Insert Chart (Check First Row Labels and First Column Labels)

Choose chart type - columns
Choose variant type - combination lines and columns

Create the chart.
Select the line series, Format Object Properties , Options choose 2nd Y axis

If you want a sorted Pareto ... select the data and sort it descending on Frequency

You can make the chart reusable by using formulas For example: assuming the data to be analysed has the category (or Bin name) in a Range called "Category"

Put the headings ( Bin, Frequency and %) at the top of columns A,B,C on a sheet and the valid values for category in column A from A2. Select the whole range and Insert Create Names (top row only)
The frequency formula in B2 is "=COUNTIF(Category;A2)"
The % formula in C2 is "=B2/SUM('Frequency')+C1"
Copy these down to cover all the categories.

You could do all this in a macro and change the range of the chart to match the number of categories.