The top five... not totally sure there... I know there is a method somewhere
in the formulae available in Excel, but I have very little experience with
that part.

But either way, I think the type of chart you want will be a pareto chart.
Here are a couple of links to help with this issue.

http://faculty.pepperdine.edu/fmadji...ts/pareto.html

http://peltiertech.com/Excel/Charts/Histograms.html

Let me know if I can help out any further.

Mark Ivey


"Paul Ilacqua" wrote in message
...
I have a data set in the form as below and need to show the top 5 issues
per month in a chart. I'm
baffled as to how and what type of chart to best show this information. I
appreciate any direction someone could send me.
YY is year , MM is month etc...
Thanks
Paul

YY MM DEFECT c_1000
2007 10 Porosity-Rear Case 2.18
2007 10 Seal Leaks-Rear O/P ID 1.71
2007 10 Porosity-Rear Retainer 1.40
2007 10 Assembly Issues-High Bolt - Case 1.32
2007 10 Assembly Issues-Tight Mainshaft Spline 1.09

2007 11 Seal Leaks-Rear O/P ID 2.64
2007 11 Porosity-Rear Retainer 2.56
2007 11 Assembly Issues-Shafts Do Not Rotate 1.92
2007 11 Leak-No Leak Found 1.52
2007 11 Assembly Issues-Tight Mainshaft Spline 1.28
2007 11 Assembly Issues-Misbuild 1.28

2007 12 Damaged-Motor 3.78
2007 12 Assembly Issues-Motor - Damaged 2.92
2007 12 Seal Leaks-Rear O/P ID 2.27
2007 12 Leak-No Leak Found 1.62
2007 12 Noise-Shift Motor Noisy During Shift 1.51

2008 1 Seal Leaks-Rear O/P ID 2.70
2008 1 Damaged-Motor 1.96
2008 1 Assembly Issues-Shafts Do Not Rotate 1.59
2008 1 Hick-All Gears 1.35
2008 1 Leak-No Leak Found 1.10