風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.Thursday,October

12,

2023Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved柏拉圖制作說明風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.制作數(shù)據(jù)表Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.不良項(xiàng)目不良數(shù)累計(jì)百分比0%凹凸4040%毛刺3070%破孔2090%脫焊10100%合計(jì)right

?

FENGSHEN

XIANGFAN

MOTOR

CO100MPANY

LTD,.

,

All

Rights

Reserved制作數(shù)據(jù)表（在EXCEL工作表中制作）將數(shù)據(jù)按從大到小的順序排列。如果有許多小項(xiàng)目的話，將數(shù)據(jù)合計(jì)為其它項(xiàng)，放在最后。不良數(shù)逐項(xiàng)累加/合計(jì)Copy風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.操作步驟1選中數(shù)據(jù)表中的不良項(xiàng)目、不良數(shù)、累計(jì)百分表將鼠標(biāo)指向圖表向?qū)ё兂伤{(lán)色Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.操作步驟2打開自定義類型，選中兩軸線-柱圖點(diǎn)下一步點(diǎn)下一步打開圖表向?qū)奢S線-柱圖Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.點(diǎn)標(biāo)題↓圖表標(biāo)題(鍵入“圖表名稱”)↓數(shù)值Y軸(鍵入“不良數(shù)”)↓次要數(shù)值Y軸鍵入“累積百分比”操作步驟3Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.點(diǎn)坐標(biāo)軸勾選□分類（X）軸（Y）Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.點(diǎn)圖例勾選□顯示圖例將□中的“√”去掉Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.點(diǎn)數(shù)據(jù)標(biāo)志勾選□值□中顯示的“√”按完成Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.將鼠標(biāo)指向次坐標(biāo)X軸點(diǎn)右鍵點(diǎn)坐標(biāo)軸格式Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.圖案→自定義→樣式找虛線→主要刻度(無)→次要刻度(無)→刻度標(biāo)簽(無)刻度按左鍵→去除﹝數(shù)值Y軸置于兩個(gè)類別之間接(B)﹞“□”中的“√”確定Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.點(diǎn)左鍵選中圖標(biāo)區(qū)后點(diǎn)右鍵，出現(xiàn)繪圖區(qū)格式單擊繪圖區(qū)格式后，在區(qū)域內(nèi)選擇白色按確定Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.將鼠標(biāo)指向繪圖區(qū)中的折線數(shù)據(jù)表中的累計(jì)百分率區(qū)域出現(xiàn)藍(lán)線用鼠標(biāo)拖動(dòng)累計(jì)百分率數(shù)據(jù)表右上角用藍(lán)線框住“0%”Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.選中繪圖區(qū)中的柱狀后，單擊鼠標(biāo)右鍵出現(xiàn)數(shù)據(jù)系列格式選擇數(shù)據(jù)系列格式中的選項(xiàng)，將分類間距中的數(shù)字改成“0”按確定Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.將鼠標(biāo)指向左坐標(biāo)軸點(diǎn)右鍵，出現(xiàn)坐標(biāo)軸格式選擇坐標(biāo)軸格式中的刻度，將最小值、最大值、分類（X）軸“□”中的“√”去除更改最大值與主要刻度單位的數(shù)值按確定Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.用同樣方法更改右縱坐標(biāo)軸Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.鼠標(biāo)移至0%上方按左鍵一次再按一次按下鍵盤上的Delete鍵Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved風(fēng)神襄樊汽車有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.（件）N=100作成：000作成日期：XX年X月X日Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY