FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReservedSaturday,OctoberSaturday,October19,202419,2024柏拉图制作说明FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved制作数据表FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved制作数据表(在EXCEL工作表中制作)不良项目不良数累计百分比0%凹凸4040%毛刺3070%破孔2090%脫焊10100%合计100将数据按从大到小的顺序排列。如果有许多小项目的话,将数据合计为其它项,放在最后。不良数逐项累加/合计FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved操作步骤1选中数据表中的不良项目、不良数、累计百分表将鼠标指向图表向导变成蓝色FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved操作步骤2打开自定义类型,选中两轴线-柱图点下一步点下一步打开图表向导两轴线-柱图FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved点标题↓图表标题(“”键入图表名称)↓数值Y轴(“”键入不良数)↓次要数值Y“”轴键入累积百分比操作步骤3FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved点坐标轴勾选□分类(X)轴(Y)FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved点图例勾选□显示图例将□中的“√”去掉FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved点数据标志勾选□值□中显示的“√”按完成FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved将鼠标指向次坐标X轴点右键点坐标轴格式FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved→→图案自定义样式找虚→线主要刻度(无)→次要刻度(无)→刻度标签(无)刻度按左键→去除﹝数值Y轴置于两个类别之间接(B)“﹞□”中的“√”确定FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved点左键选中图标区后点右键,出现绘图区格式单击绘图区格式后,在区域内选择白色按确定FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved将鼠标指向绘图区中的折线数据表中的累计百分率区域出现蓝线用鼠标拖动累计百分率数据表右上角,用蓝线框住“0%”FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved选中绘图区中的柱状后,单击鼠标右键出现数据系列格式选择数据系列格式中的选项,将分类间距中的数字改成“0”按确定FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved将鼠标指向左坐标轴点右键,出现坐标轴格式选择坐标轴格式中的刻度,将最小值、最大值、分类(X)轴“□”中的“√”去除更改最大值与主要刻度单位的数值按确定FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved用同样方法更改右纵坐标轴FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved单击坐标轴标题,出现坐标轴标题格式后,点对齐中的方向,选择文本确定FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved鼠标移至0%上方按左键一次再按一次按下键盘上的Delete键FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReservedN=100作成:000作成日期:XX年X月X日(件)FENGSHENXIANGFANMOTORCOMPANYLTD,.风神襄樊汽车有限公司Copyright©FENGSHENXIANGFANMOTORCOMPANYLTD,.,AllRightsReserved谢谢!