为么同事做出来的Excel图表这么好看？【Excel教程】
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iaa8r7PJoyAtlfHAKe8RosE3lG8odjewibU9OPaLFmBsjaLABbjECljAfoRt5uURQMZnYAgIDK8MkKw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><strong style="color: blue;">关注回复[</strong><strong style="color: blue;">目录</strong><strong style="color: blue;">]学习113篇Excel教程</strong></span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyNDmBGzGRtxMH3iaH2Y4ymrult7ic3Qxz8fZib5LJF78otFT256MRPNwoSMUx1E4frA4Lsiaj2P6XwSA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">全套Excel视频教程，扫码观看</strong></span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">绩效展示<span style="color: black;">必定</span>是<span style="color: black;">大众</span>工作中经常需要做的事情。<span style="color: black;">区别</span>的表现形式带来的效果可能完全不<span style="color: black;">同样</span>。你的老板<span style="color: black;">每日</span>要审核<span style="color: black;">那样</span>多的工作，他并不<span style="color: black;">晓得</span>你做了多少工作、加了多少班，只能从你的图表中看你工作的结果， 此时<span style="color: black;">倘若</span>你的图表让他眼前一亮，那你升职<span style="color: black;">亦</span>就指日可待啰！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">例如</span>利用下图数据大部分人<span style="color: black;">能够</span>用excel自带的柱形图来完成任务。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TlIE6pppsAgbG2a2Ip80bfxib7O8yGSjPpa5wV63UN8Kiaia1w0kr5JMxA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">做出来效果如下图。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TjtsPYrXibPPWESxv0fFBeVko2ku6ZAYribNVmKtl4r6fz5fljpbzLfbQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">从图中<span style="color: black;">咱们</span><span style="color: black;">没法</span>直观的看出<span style="color: black;">那些</span>人是优秀的，<span style="color: black;">那些</span>人是达标的，<span style="color: black;">那些</span>人是未及格的。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天<span style="color: black;">咱们</span>学习制作一个逼格满满的图表——子弹图。在描述<span style="color: black;">实质</span>达成水平和<span style="color: black;">目的</span>等级的差异时，<span style="color: black;">一般</span><span style="color: black;">能够</span><span style="color: black;">选择</span>子弹图<span style="color: black;">做为</span>阐述的图表，能够清楚的显示出<span style="color: black;">目的</span>、等级和<span style="color: black;">实质</span>之间的差异。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">咱们</span><span style="color: black;">最后</span>要完成以下效果图。这么优秀的图表，必定能够<span style="color: black;">导致</span>老板对你的刮目相看。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tia8BUkmpzk4orQniaCJUuErqvv8RlUjy7iap7Zc4nQpvQUpvnkqwOwEJA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">QQ群：806440210下载练习课件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1、</span></strong><strong style="color: blue;">制图<span style="color: black;">过程</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">1. </strong><strong style="color: blue;">处理原始数据</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">通常</span><span style="color: black;">状况</span>下，原始数据并不是比较好的制图数据。<span style="color: black;">因此</span>要制作一张优秀的图表的<span style="color: black;">第1</span>步是将原始数据处理成需要的制图数据。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">原始数据还是前面的例子，如下：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TnneNUx13AnAIOLCUSHrekXF31bCG4wedsVZlZpnSAIKUOKvzzmdHvw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">最后</span><span style="color: black;">咱们</span>做成如下所示的表格，<span style="color: black;">做为</span>制图数据。这个表格在原数据中添加了4种数据，所有人的<span style="color: black;">目的</span>都定为80，达到60定为及格，61-80为良好，<span style="color: black;">由于</span><span style="color: black;">咱们</span>要做堆积图，良好最大值比及格高20，在下图中就填写20，81-100定为优秀，<span style="color: black;">因此</span>优秀列<span style="color: black;">亦</span>填写20。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TYzZy6mIG17HiaZehyCHvW0aibFqlIOIGoPgRB2HIXiaAmaPmr8lq8ggGQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">2. </strong><strong style="color: blue;">制作堆积柱形图</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中区域A2:F7,点击菜单栏“<span style="color: black;">插进</span>”，<span style="color: black;">选取</span>“柱形图”，再<span style="color: black;">选取</span>“堆积柱形图”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TiacOECbeqQLibQe2tnicl8d8ohjvTyEXxOXkq8650jyQSMgxBpEHRQXug/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">得到下面的图表；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TRaFKLkhtibaShLQdM9VhsRYIoeAKj5EDxfISsDaiaicH3wWibyGKd1e4kQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">上图的横坐标是五个数据类别，<span style="color: black;">例如</span>说<span style="color: black;">营销</span>业绩柱形条<span style="color: black;">暗示</span>的是<span style="color: black;">每一个</span>人的<span style="color: black;">营销</span>业绩的堆叠。<span style="color: black;">咱们</span>需要的是以人名为横坐标<span style="color: black;">每一个</span>人为一个柱形条。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中表格，单击右键，在弹窗中点击“<span style="color: black;">选取</span>数据”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1T1HRk0xWdoEQ0Hf1cnZtTiaZ4x22quWsHib0ceVcUZibBT6w5ruamla9hw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，点击“切换行／列”，得到横坐标为人名的图。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tu2PO0EHWcmkgg9baQibtUqBFicKSQhoOCgfU7wnM0ORkIcGrbQ1SicsMA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">每一个柱形条都<span style="color: black;">表率</span>一个人的数据，<span style="color: black;">包含</span><span style="color: black;">营销</span>业绩、<span style="color: black;">目的</span>、及格、良好和优秀5种数据。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1T5IZ6ichNrv0HfDlibPoTZfhl4w5iadENQPWicibZMHRztVDVp8gEEgBKbJg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">3.</strong><strong style="color: blue;">设置<span style="color: black;">目的</span>横线</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击选中“<span style="color: black;">目的</span>”图例，单击右键，在弹窗中<span style="color: black;">选取</span>“更改图表类型”，<span style="color: black;">选取</span>“折线图”，此时<span style="color: black;">目的</span>系列变成一条横线；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TfOwRiagzYmjEpEqbV8K4QzEiaQ8vvto61mg4aybFL3Blv8gK8UHSwYYQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TZDppFqzYsb5MJrqSUhWr7vwKuhYNOUk7Sq612PFziaZNzJP6LHszNicg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击<span style="color: black;">目的</span>横线，单击右键，<span style="color: black;">选取</span>“设置数据系列格式”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TBJIk4djZST3F0Ko9ksbgmFHlNaRqRnQNAasAcRia9pKFx8jaOWMeiauA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，<span style="color: black;">选取</span>油漆桶选项，<span style="color: black;">选取</span>“线条”，点击“无线条”；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TXApluIkshpLHBBfLcyp6u7cqibl3kdtnicibyjuxfAlmCCpt87V14j5xA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在上面设置线条的弹窗中，<span style="color: black;">选取</span>“标记”选项，在数据标记选项中<span style="color: black;">选取</span>“内置”，类型为横线，<span style="color: black;">体积</span>为40；在填充选项中<span style="color: black;">选取</span>填充色为红色（FF0000）。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1T0Am8AX6HM9PKv6Rkg4SWZ1EibwWIP851EqaM1EeY4Af4620I8tuCMTw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">得到下图：</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TV6ocTrVSibvK1aEB6AczUARl5zXdN1wyZgtzK7ibQ1hPGM1VxsTia4Ifg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">4.</strong><strong style="color: blue;">设置<span style="color: black;">营销</span>业绩系列</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击选中<span style="color: black;">营销</span>业绩的图例，单击右键，选中“设置数据系列格式”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TiarAfYGheChVB2MqfyZex1XvczVlBD98DRuia8zzR8KgPa4xypcicw3gA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，<span style="color: black;">选取</span>系列绘制在次坐标轴，间隙宽度为350%；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tk7l7UpyNp8AaibHQNUrTJzE71NMYl45KibKfMJxJPv7f576q4mNlvD8A/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">更改<span style="color: black;">营销</span>业绩柱形图的填充色。点击油漆桶图标，点击填充下的颜色按钮，点击“<span style="color: black;">更加多</span>颜色”，并且在弹窗中输入“EF8B3F”,得到下图的效果；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TiaxLN8vZ5xiaLnBAVO8icL6rcU0Cv3hnzO5Vm2gxRW9IeQYznPZLqGKRQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tv2UZsowCyq3O7KmQSiaCictE6sibEJk4BmaINib42P2fpyjTibAn2IxH0bA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点击右边的次坐标轴，单击右键，在下拉菜单中<span style="color: black;">选取</span>设置坐标轴格式。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TDC3hVb903vmxaEs19sfJabSjxYqFFSfSmIicnET6nnPbFwcM5ceG5XA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，将最大值设置成120，跟主纵坐标轴<span style="color: black;">同样</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tw6tqLiaD4A8gbHHejZbnrDQo1FxUTAHjia7RbGB0pYX0DZaTSibnA5f9w/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">删除次坐标轴，得到下面的效果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TrPcic7YtaLyqlaMn4QUfJ4HkF7cHicgCR7gQQJdiadht3dBuCstvdVUCQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2、</span></strong><strong style="color: blue;">美化图表</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1.点击“及格”图例，单击右键，<span style="color: black;">选取</span>“设置数据系列格式”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1Tqeqiat82FTHssrY6JUWJhzoib9RKXAnxhyxgeIFuTAjtq2ibDEq8SHOiaw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，点击油漆桶图标，在填充选项中，更改颜色为“5B5754”。对良好和优秀系列同理操作，将良好系列填充色更改为“A5A6AA”，将优秀系列填充色更改为“D8D8D8；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TAWJ0wwW0ofTvAGcdAAtlicfPiad70Kzyom51d7p54ZuF0h5Blg7lP9ibQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2.点击图例区域，单击右键，选中设置图例格式。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TpWylNDuwP2JRicnMvnjlNoKgR3lnvsJmQoGeB8VxWrcOgYdXibqYfSMQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在弹窗中，<span style="color: black;">选取</span>图例位置为“上”。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TwlONHK1FbtTibb1NkaFASibBjXpV6WPbyuQfY7aHY9wqGz8bgia6GeSBw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3.点击选中<span style="color: black;">营销</span>业绩的柱形图，单击右键，选中添加数据标签。<span style="color: black;">而后</span>把数据标签选中后拖动到柱形图的上方；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TfHXr6yOpsIDsmv6NNLicARMMjBUTcnicicLiaF9rZQesakaIsVVDS0BIwA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">4.<span style="color: black;">倘若</span>有标题，则<span style="color: black;">能够</span>把标题更改为需要的。<span style="color: black;">这儿</span>，我把标题删掉，<span style="color: black;">最后</span>得到以下效果图。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMzQ7K71FQ8KcCkmYArWZl1TOpKnDWgJz1YNRLC998RCFtHNoibMQG19zJkIjvtv7xOddXHvKFox8xw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3、</span></strong><strong style="color: blue;">学习反思</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">今天学习的子弹图<span style="color: black;">重点</span>的功能是能在一张图直观的表达出<span style="color: black;">实质</span>和<span style="color: black;">目的</span>的差异，<span style="color: black;">同期</span><span style="color: black;">晓得</span><span style="color: black;">处在</span>哪个<span style="color: black;">周期</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">重点</span>难点是<span style="color: black;">营销</span>业绩的次坐标轴设置。为了达到<span style="color: black;">营销</span>业绩柱形条变窄，必须将其绘制在次坐标轴。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">咱们</span><span style="color: black;">能够</span>将主坐标轴和次坐标轴理解成两张叠在<span style="color: black;">一块</span>的图。<span style="color: black;">倘若</span>在同一个坐标轴绘制图表时，<span style="color: black;">由于</span>坐标轴的刻度是<span style="color: black;">同样</span>的，<span style="color: black;">因此</span>柱形图的宽度都是<span style="color: black;">同样</span>的。<span style="color: black;">增多</span>了次坐标轴，刻度<span style="color: black;">能够</span>和主坐标轴不<span style="color: black;">同样</span>，<span style="color: black;">能够</span>设置其宽度，实现宽度不<span style="color: black;">同样</span>的效果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最后<span style="color: black;">期盼</span>这篇子弹图的教程能够在平时工作中<span style="color: black;">帮忙</span>到<span style="color: black;">大众</span>，快快地升职加薪！！！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">想要全面系统学习Excel，不妨关注部落窝教育《<span style="color: black;">1星期</span>Excel直通车》视频课<span style="color: black;">或</span>《Excel极速贯通班》直播课。</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">《<span style="color: black;">1星期</span>Excel直通车》</strong></span>视频课</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span>Excel技巧、函数公式、</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">数据透视表、图表。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">一次购买，永久学习。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">最实用接地气的Excel视频课</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">《<span style="color: black;">1星期</span>Excel直通车》</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">38 </strong></span><span style="color: black;">节视频大课</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">理论+实操一应俱全</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">主讲老师： 滴答</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Excel技术大神，资深培训师；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">课程粉丝100万+；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">研发</span>有《Excel小白脱白系列课》</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 《Excel极速贯通班》。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">原价299元</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">限时特价</span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">99</span></strong></span></span><span style="color: black;">元，随时涨价</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">少喝两杯咖啡，少吃两袋零食</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">就能习得受用<span style="color: black;">一辈子</span>的Excel职场技能！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"> 长按下面二维码立即购买学习</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">购课后，加客服<span style="color: black;">微X</span>：blwjymx领取练习课件</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">爆文<span style="color: black;">举荐</span>：</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><strong style="color: blue;">“同事都下班了，我却被数据透视表困住，<span style="color: black;">此刻</span>慌得一比”【Excel教程】</strong></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><strong style="color: blue;">“帮我把这1000行数据每7行一页打印出来，3分钟内我就要！”【Excel教程】</strong></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><strong style="color: blue;">逆天了！excel表格中<span style="color: black;">这般</span>拖动鼠标，竟可</strong></a><strong style="color: blue;">以<span style="color: black;">处理</span>90%的工作<span style="color: black;">困难</span>【Excel教程】</strong></p>
i免费外链发布平台 http://www.fok120.com/ 你的话语如春风拂面，让我感到无比温暖。 外贸论坛是我们的，责任是我们的，荣誉是我们的，成就是我们的，辉煌是我们的。
页:
[1]