搜档网
当前位置:搜档网 › 用excel制作柏拉图

用excel制作柏拉图

43658 43659 43660 43660 43661 43661 43662 43663 Date7/127/137/147/147/157/157/167/17生產線別ASSA ASSA ASSC ASSC ASSC ASSC ASSB ASSB 生產班別白班白班白班夜班白班夜班白班白班生產總數700110035055060030010001130檢驗數6412832404032104104檢驗部件數448896224280280224728728檢驗不良數24000033檢驗不良率0.4%0.4%0.0%0.0%#REF!0.0%0.4%0.4%目標15001500150015001500150015001500實績4464446400#REF!041214121

图表标题

4500

4000

3500

3000

2500

2000

0 500 1000 1500 A S S C 白班 350 32

224 0 0.0% 1500 0

7/14 7/16 0 0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

0 50

100

150 200 250 300

350 图表标题 7/14 7/16

43663 43668 43668 43670 43671 43672 43673 43674 43675 7/177/227/227/247/257/267/277/287/29 ASSC ASSC ASSC ASSD ASSD ASSD ASSD ASSD ASSD 白班白班夜班白班白班白班白班白班白班300560540300630670790800780 321283296721261289672 224896224672504882896672504 020347911 0.0%0.2%0.0%0.4%0.8%0.8% 1.0%0.1%0.2% 150015001500150015001500150015001500 0223204464793779371004514881984

0.8

0.9 1 图表标题

0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0

43676 43677 43678 43678 43679 43679 43680 43680 43682 7/307/318/18/18/28/28/38/38/5 ASSD ASSD ASSD ASSD ASSD ASSD ASSD ASSD ASSD 白班白班白班夜班白班夜班白班夜班白班840870105090010209301150950200 1361601041049610410410432 9521120728728672728728728224 41116326090 0.4% 1.0%0.1%0.8% 4.8%0.8%0.0% 1.2%0.0% 150015001500150015001500150015001500 42029821137482424761982420123630

43682 43683 8/58/6 ASSD ASSD 夜班夜班950350 10432 728224 110 1.5%0.0% 15001500 151100

相关主题