How I do the pareto charts?

[Guest]

I need generate a pareto chart with all its rules, but i don't know how I can
modificate the charts for my needs....

 

[Guest]

The easiest way to create a pareto chart is to select your data and choose
the command Tools, Data Analysis, Histogram, and check the Pareto and Chart
options after you fill out the top of the screen.

The Data Analysis command is part of the Analysis ToolPak, to install that
choose Tools, Add-ins and check Analysis ToolPak (VBA one not necessary).

 

[Ed Ferrero]

Have you tried the Microsoft template at
http://office.microsoft.com/en-us/templates/TC060827611033.aspx?pid=CT101443491033

Ed Ferrero

 

[Guest]

Hi,

I might add that a Pareto chart is just a sorted histogram. So if you want
to do it manually just sort your data descending. Plot a column chart.
Double click the series on the chart and choose Options and set the Gap Width
to 0.