Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Chart
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart formatting and chart templates in Excel 2007 | Charts and Charting in Excel | |||
Excel 2007 Chart - determining the color of a chart style | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Excel 2003: How to nudge a chart element or shape on a chart? | Charts and Charting in Excel |