Create Pareto Chart in Excel?

T

Tycon22

Thanks for the responses. The data is in a sorted frequenc
distribution. I have the data analysis add-in installed, but i couldn'
locate the data analysis pull down or the histogram with pareto option
I'm running excel 2000, I can still create a pareto with this versio
correct
 
J

Jerry W. Lewis

The bottom entry on the Tools menu should be "Data Analysis".

If it is not there, then you do not have the Analysis ToolPak loaded.
In that case, go to Tools|Add-Ins and check "Analysis ToolPak"

If Analysis ToolPak is not in the Add-Ins list, then you need to run the
installation program from the Office CD and update your installiation by
installing Analysis ToolPak.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can i make pareto chart on 2 axis in excel? 1
Excel Add Ins 2
Pivot Tables and Pareto Charts 1
pareto chart in Excel 2007? 1
Create Pareto Chart in Excel? 4
How do you create combination charts (line-coulmn) in excel 2007? 1
How do I set up a Pareto chart in Excel? 1
Data Table at Base of Chart 4

Top