品管圈柏拉图制作

1、Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,品管圈柏拉图制作,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,建立数据表,打开一个,EXCEL,文档，建立数据统计表,选择缺陷项目、缺陷,数和累计百分比,Supplementary Reading,After Rea

2、ding,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,选择“插入”，创建,一个柱状图,创建一个柱状图,选择累计比图形，右,键选择“更改系列图,表类型,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,选择,XY,散点,图）”，选择“带平,滑线和数据标记的散,点图”，点击确定,选择图表上方的“次坐标,水平轴”，按右键选择,设置坐标轴格式,

3、Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,在“坐标轴选项”中将最,小值固定为,0.0,，最,大值固定为需要的数值,再将“坐标轴标签”改为,无”后点击关闭,选择图表右方的“次坐标,垂直轴”，按右键选择,设置坐标轴格式,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life

4、,在“坐标轴选项”中将最,小值固定为,0.0,，最,大值固定为,1.0,在“设置坐标轴格式”中,的“数字”中，点击数字,类别为“百分比”，点击,关闭,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,选择图表左方的“垂直,轴”，按右键选择“设置,坐标轴格式,选择“坐标轴选项”，将,最小值固定为,0.0,将最大值固定为,136,Supplementary Reading,After Reading,Detailed Reading,G

5、lobal Reading,Before Reading,Unit 6 The Pace of Life,左键点击柱状图，再点击,右键，选择“设置数据系,列格式,在“系列选项”中分类间,距设置为“无间距”，百,分比为,0,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,删除图表右侧的图例,添加数据标签：选择柱状,图，按右键选择添加数据,标签,Supplementary Reading,After Reading,Detailed

6、Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,左键选择柱状图，按右键,选择“设置数据标签格,式”，在标签位置中随意,选择,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,同理设置曲线的数据,Supplementary Reading,After Reading,Detailed Reading,Global Reading,Before Reading,Unit 6 The Pace of Life,余同柏拉图,一”，根据,需要设置自己,喜欢的格式和,样式,Supplemen