|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
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
|