柏拉图操作说明

风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.Thursday,October

12,

2023Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved柏拉图制作说明风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.制作数据表Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.不良项目不良数累计百分比0%凹凸4040%毛刺3070%破孔2090%脫焊10100%合计right

©

FENGSHEN

XIANGFAN

MOTOR

CO100MPANY

LTD,.

,

All

Rights

Reserved制作数据表（在EXCEL工作表中制作）将数据按从大到小的顺序排列。如果有许多小项目的话，将数据合计为其它项，放在最后。不良数逐项累加/合计Copy风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.操作步骤1选中数据表中的不良项目、不良数、累计百分表将鼠标指向图表向导变成蓝色Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.操作步骤2打开自定义类型，选中两轴线-柱图点下一步点下一步打开图表向导两轴线-柱图Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.点标题↓图表标题(键入“图表名称”)↓数值Y轴(键入“不良数”)↓次要数值Y轴键入“累积百分比”操作步骤3Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.点坐标轴勾选□分类（X）轴（Y）Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.点图例勾选□显示图例将□中的“√”去掉Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.点数据标志勾选□值□中显示的“√”按完成Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.将鼠标指向次坐标X轴点右键点坐标轴格式Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.图案→自定义→样式找虚线→主要刻度(无)→次要刻度(无)→刻度标签(无)刻度按左键→去除﹝数值Y轴置于两个类别之间接(B)﹞“□”中的“√”确定Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.点左键选中图标区后点右键，出现绘图区格式单击绘图区格式后，在区域内选择白色按确定Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.将鼠标指向绘图区中的折线数据表中的累计百分率区域出现蓝线用鼠标拖动累计百分率数据表右上角用蓝线框住“0%”Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.选中绘图区中的柱状后，单击鼠标右键出现数据系列格式选择数据系列格式中的选项，将分类间距中的数字改成“0”按确定Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.将鼠标指向左坐标轴点右键，出现坐标轴格式选择坐标轴格式中的刻度，将最小值、最大值、分类（X）轴“□”中的“√”去除更改最大值与主要刻度单位的数值按确定Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.用同样方法更改右纵坐标轴Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.鼠标移至0%上方按左键一次再按一次按下键盘上的Delete键Copyright

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY

LTD,.

,

All

Rights

Reserved风神襄樊汽车有限公司FENGSHEN

XIANGFAN

MOTOR

COMPANY

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

©

FENGSHEN

XIANGFAN

MOTOR

COMPANY