资源描述：
《用excel 2013制作帕累托图》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、用Excel2013制作帕累托图1．做出累计百分比和累计件数的列表，并在字段名（第1行）下空出一行留给累计百分比0%。beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespac
2、ingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．选择“原因”、“件数”和“累计百分比”表格（A1:C9）——点击“插入”选项卡——选择“组合图”——选择“簇状柱形图–次坐标上的折线图”beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6
3、enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．点击主坐标轴的纵坐标（或是在“坐标轴选项”中选择“垂直（值）轴”）beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedontheterminalstripterminals,onlineidenti
4、tyandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．在页面中将“最大值”改为累计件数的最大值beconsistentwithinthesamedisk.Alternateunifiedcorerequirementsplacedonthetermin
5、alstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．选择次坐标轴垂直（值）轴beconsistentwithinthesamedisk.Alternateunifiedcorerequirem
6、entsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．把边界的最大值改为1beconsistentwithinthesamedisk.Alternate
7、unifiedcorerequirementsplacedontheterminalstripterminals,onlineidentityandensurethecoppercoreisnotexposed.6.4.6enclosurewithinthesametothecablecoreprovidesbindingintoacircle,harnesstiespacingisgenerally100mm;branchofficesshallbebindingonbothends,eachcore1．点击柱形图——拖动紫色框的右上角，去掉其数据源中的空格行
