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
