LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy chart formatting and chart templates in Excel 2007 Astelix Charts and Charting in Excel 4 March 4th 10 04:10 AM
Excel 2007 Chart - determining the color of a chart style Shane Devenshire[_2_] Charts and Charting in Excel 1 February 6th 10 04:09 AM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Charts and Charting in Excel 2 March 6th 09 04:43 PM
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard Julius Setting up and Configuration of Excel 1 March 6th 09 01:57 AM
Excel 2003: How to nudge a chart element or shape on a chart? Ted M H Charts and Charting in Excel 5 June 30th 08 07:08 PM


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"