Pareto chart

  • Thread starter Thread starter sekretar
  • Start date Start date
S

sekretar

Hi...
how to create pareto chart? Is it easy?
It even hasnt be in excel, any free software?
 
To make a pareto chart, sort your data in descending order of the numerical
value (counts, instances, whatever), then make a column chart. If you want
the line showing cumulative amounts, in the next column use a formula to
construct a running sum*, add that to the chart (it will first be another
set of columns), select it, go to the Chart menu > Chart Type, and choose a
line type.

*for a running sum, suppose your labels are in cells A2:A10, your numbers
are in B2:B10. Select C2, enter this formula:

=sum(C$2:C2)

Copy this down to fill C2 through C8

- Jon
 
Back
Top