Pareto Chart

[Guest]

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

Thank you, Karen

 

[Guest]

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

 

[Mike Middleton]

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

 

[Guest]

Thank you for your help
Karen

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

 

[Guest]

Thank you for your help
Karen

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