Pareto Chart
 

Is there a way of creating a pareto chart in Excel 2003?

Thank you, Karen

Pareto Chart
 

tools-data analysis-histogram the add-ns must be activated

"Karen" wrote:

Is there a way of creating a pareto chart in Excel 2003?

Thank you, Karen

Pareto Chart
 

Karen -

A Pareto chart is usually a histogram of frequencies for categorical or text
data, with the categories ordered by frequency.

If you have a list of text data, you could use COUNTIF or a Pivot Table to
obtain the frequencies. Then sort, and create a Column chart type.

You'll find instructions if you search Google for "Excel pareto chart"
(without the quotes).

The Analysis ToolPak has a Histogram tool, and the Histogram tool has a
"Pareto (sorted histogram)" option, but the tool is limited to using only
numerical data, so it's useless for the construction of a sorted histogram
based on text data.

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


"Karen" wrote in message
...
Is there a way of creating a pareto chart in Excel 2003?

Thank you, Karen

Pareto Chart
 

Thank you for your help
Karen

"bj" wrote:

tools-data analysis-histogram the add-ns must be activated

"Karen" wrote:

Is there a way of creating a pareto chart in Excel 2003?

Thank you, Karen

Pareto Chart
 

Thank you for your help
Karen

"Mike Middleton" wrote:

Karen -

A Pareto chart is usually a histogram of frequencies for categorical or text
data, with the categories ordered by frequency.

If you have a list of text data, you could use COUNTIF or a Pivot Table to
obtain the frequencies. Then sort, and create a Column chart type.

You'll find instructions if you search Google for "Excel pareto chart"
(without the quotes).

The Analysis ToolPak has a Histogram tool, and the Histogram tool has a
"Pareto (sorted histogram)" option, but the tool is limited to using only
numerical data, so it's useless for the construction of a sorted histogram
based on text data.

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


"Karen" wrote in message
...
Is there a way of creating a pareto chart in Excel 2003?

Thank you, Karen