柏拉圖操作說明

風(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,.不良項目不良數(shù)累計百分比0%凹凸4040%毛刺3070%破孔2090%脫焊10100%合計right

?

FENGSHEN

XIANGFAN

MOTOR

CO100MPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

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

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

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

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

LTD,.點標(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,.點坐標(biāo)軸勾選□分類（X）軸（Y）Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

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

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

LTD,.點數(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軸點右鍵點坐標(biāo)軸格式Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

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

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

LTD,.點左鍵選中圖標(biāo)區(qū)后點右鍵，出現(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ù)表中的累計百分率區(qū)域出現(xiàn)藍(lán)線用鼠標(biāo)拖動累計百分率數(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ù)系列格式中的選項，將分類間距中的數(shù)字改成“0”按確定Copyright

?

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

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

XIANGFAN

MOTOR

COMPANY

LTD,.將鼠標(biāo)指向左坐標(biāo)軸點右鍵，出現(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