| Home |
| Search |
| Today's Posts |
|
#5
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a pareto chart | Charts and Charting in Excel | |||
| Pareto Chart | Charts and Charting in Excel | |||
| how do you create a Pareto Chart | Charts and Charting in Excel | |||
| Auto Pareto Chart | Charts and Charting in Excel | |||
| How do I set up a Pareto chart in Excel? | Charts and Charting in Excel | |||
Threaded Mode
