用Excel 2013制作帕累托图.docxVIP

用Excel 2013制作帕累托图做出累计百分比和累计件数的列表，并在字段名（第1行）下空出一行留给累计百分比0%。选择“原因”、“件数”和“累计百分比”表格（A1:C9）——点击“插入”选项卡——选择“组合图”——选择“簇状柱形图 – 次坐标上的折线图”点击 主坐标轴的纵坐标（或是在“坐标轴选项”中选择“垂直（值）轴”）在页面中将“最大值”改为累计件数的最大值选择次坐标轴 垂直（值）轴把边界的最大值改为1点击柱形图——拖动紫色框的右上角，去掉其数据源中的空格行（不清楚的对比下一张图）此为去除空格行之后的效果，同理完成蓝色框点击“图表工具”的“设计”选项卡——“添加图表元素”——“坐标轴”——“次要横坐标轴”点击次要横坐标轴——将“坐标轴位置”中的“刻度线之间”改为“在刻度线上”更改“标签位置”为“无”点击折线图——右键——添加数据标签点击柱状图——在中将“分类间距”改为“0”最后把每个柱状体设为不同的颜色，完成如有疑问、需要转载或该文档需要改正，请加QQ：183158696armed Marx doctrine of Chinese consciously use the latest achievements of the armed minds, guiding practice, and promote the work. With a high degree of political consciousness, bureau Party led the study and implement the spirit of general secretary Xi Jinpings important speech series, and timely to the cadres and workers to study and implement of special supervision and inspection (. Eleven) the text will be more and morearmed Marx doctrine of Chinese consciously use the latest achievements of the armed minds, guiding practice, and promote the work. With a high degree of political consciousness, bureau Party led the study and implement the spirit of general secretary Xi Jinpings important speech series, and timely to the cadres and workers to study and implement of special supervision and inspection (. Eleven) the text will be more and morearmed Marx doctrine of Chinese consciously use the latest achievements of the armed minds, guiding practice, and promote the work. With a high degree of political consciousness, bureau Party led the study and implement the spirit of general secretary Xi Jinpings important speech series, and timely to the cadres and workers to study and implement of special supervision and inspection (. Eleven) the text will be more and more