How I do the pareto charts?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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....
 
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).
 
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.
 
Back
Top