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.
 

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
Pareto Chart 1
Excel Add Ins 2
Trendline partial data start point 1
How do you create combination charts (line-coulmn) in excel 2007? 1
pareto charts 2
Pareto charts 1
how do you create a Pareto Chart 2

Back
Top