Paretochart

[Gopinath P]

How do we create a Parechart in Excel ??

 

[Gopinath]

Sorry, Thats ParetoChart !!!

 

[S. Daum]

A Pareto chart is a bar chart where the bars are ordered (usually
descending). It let's you visualize the 80/20 rule which was described by a
guy name Vilfredo Pareto. I'm guessing you'll sort your data (usually
categories and counts) in the sheet and then create a bar chart. Read more
here:

http://www.qualityadvisor.com/sqc/interpretation/pareto-interpret.htm

 

[Jon Peltier]

If you have installed the Analysis Toolpack, run Data Analysis from the
Tools menu, and choose Histogram. One of the options is Pareto (Sorted
Histogram). This assumes that the raw data hasn't been compiled into
bins yet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

Happened to remember the number, just like that?

- Jon

 

[alani]

Look here
http://www.excelforum.com/showthread.php?s=&postid=591148#post59114