90后小姐姐用excel制图前做了1个过程，工资直接从4000涨到6000【Excel教程】
<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;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;">全套Excel视频教程，<span style="color: black;">微X</span>扫码观看</strong></span></strong></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><span style="color: black;">下表是各分<span style="color: black;">机构</span>10月份上中下旬的营收数据，<span style="color: black;">此刻</span>需要<span style="color: black;">经过</span>柱状图表对比每旬各分<span style="color: black;">机构</span>的营收<span style="color: black;">状况</span>。 </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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuCklKORkbKXSRLjnnRNxJBJVicd09hnPYZVZVgKgmiaOXT53HeAhfqSPw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"><span style="color: black;">首要</span><span style="color: black;">瞧瞧</span>默认图表。</span><span style="color: black;">（1）选中A2:D7数据区域，按Alt+F1快速<span style="color: black;">插进</span>柱状图。</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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuzYADm3ZwjbgQGRxMIedO304FbH6DWFxiaeFUnuom3iaRC5hKWYTFSokA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> 图表以分<span style="color: black;">机构</span>分组，每组表达了上中下三旬数据。</span><span style="color: black;"><span style="color: black;">这般</span>的图表达到<span style="color: black;">需要</span>了吗？</span><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><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><span style="color: black;">（2）下面做<span style="color: black;">调节</span>，将行列进行切换。选中柱状图，<span style="color: black;">选取</span>图表工具“设计”选项卡，单击“切换行/列”按钮。</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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuM122J0zTlIvp7d8834XnwXa10oqAUvfYR37FehjPL6ibfvBdxGFCvJA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> <span style="color: black;">运用</span>Excel低版本的用户可能需要选中柱状图右击<span style="color: black;">选取</span>“<span style="color: black;">选取</span>数据”命令，在打开的“<span style="color: black;">选取</span>数据源”对话框中切换行列。</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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeu1ico3444mqBxzdfnChMmudicq7OKuOaFNFAU9VI04ibakAH97jvicGyPxg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> 切换行列后图表<span style="color: black;">出现</span>了变化。 </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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuuykt1yCBqcNRXvTza4aR33x6AsY15JrPqZ3asm01cNPyKdMvcibl27g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> 每旬对应的各分<span style="color: black;">机构</span>汇聚为一组，基本达到了分析<span style="color: black;">目的</span>：对比每旬各分<span style="color: black;">机构</span>的营收。</span><span style="color: black;">但<span style="color: black;">此刻</span>的图表令人满意吗？</span><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 style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeu04NCWFqk9xpiaZken9Fy1NialAWMzckCyG9a8VYyK5AQR7ySP8dxpjcA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeu6EvXuZ2q5bvqQXLWbVGwRr0wgmpAjLicAC8FN5hF2gM6iaD4IonVm5FQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> 下面<span style="color: black;">咱们</span><span style="color: black;">经过</span>“占位”方式重新制作柱状图，将上中下旬清晰地分为三组。</span><span style="color: black;">（3）<span style="color: black;">首要</span>需要将原始表格数据做如下<span style="color: black;">调节</span>： </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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuTXDezKPbXzj9vCr2YtIJ0cjE7nIPpdRWUFSqFyPVJyDrv2ibZyMNibOg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">（4）<span style="color: black;">而后</span>选中A2:D19数据区域按Alt+F1<span style="color: black;">插进</span>柱状图，如下图所示：</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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuxwj1ZibcMAjuSSe6MGic8hHibMz1icgnCJ0JD3pH9vREMcolicLuRPQnnGQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> （5）取消坐标，<span style="color: black;">调节</span>系列重叠和间隙宽度值，<span style="color: black;">就可</span><span style="color: black;">得到</span>一张比较满意的原始图表： </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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeu6EvXuZ2q5bvqQXLWbVGwRr0wgmpAjLicAC8FN5hF2gM6iaD4IonVm5FQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;"> 到<span style="color: black;">这儿</span>，剩下的只是进一步的美化<span style="color: black;">调节</span>。 </span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuYszL5IMjRGugYqImdYwJkVcdrHLDWDGxlxbFpOL5dibtzWeJVTgRicWA/640?wx_fmt=jpeg&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;"><span style="color: black;">总结：</span></strong></span><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 style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuzQW1pKeYMKc7FBUKw5lNz6pKUDkch2yseYpiatYQ5ya0RFhatyHcThA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">那<span style="color: black;">怎样</span>实现行标题标注在每根柱形下，图表好似按列标题分组的呢？</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/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeu3hEZxePutFfy73j5avepNPia5yDdGTjByM4Bj5qUAib5ib7Uwn2AMhtIw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">很简单，复制两组数据源，将3组数据表达在同一个图表中；<span style="color: black;">而后</span>删除数据，每组只<span style="color: black;">保存</span>一旬<span style="color: black;">区别</span>的数据，利用空值占位，实现按列标题分组的效果，动图如下： </span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMySq3RV8kgfHv7ATM9bFWeuF5zQtFfFtaXmZky5fvXlztqD98licEhicwDhTiaGfVctTicXHriaXFfyHibg/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>扫一扫添加老师<span style="color: black;">微X</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMz29ibCptW68SVvcH9rzSICcXPldEqgfiaUkWzUzunVc3JDGf6e52kZ7eicfESEVpAvtWIwmKSEIEyfw/640?wx_fmt=jpeg&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;">在线咨询Excel课程</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iabwjyojLhA03PtxUnkNPREnYMIXQoTgtW6libdMibQVNic3eZhU08VyWfSQWdI82zIYSzSTq4Y3YV9nQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">辞职前，我用Excel做</span></a>了这个“骚”操作，把前老板吓傻了！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">史上最“废柴”的excel函数，花两个小时，完<span style="color: black;">成为了</span>5分钟的工作！？？【Excel教程】</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">天天用透视表，这3招我居然才<span style="color: black;">晓得</span>，不要太好用！【Excel教程】</span></a></p><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 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="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMw9HqsFgNibg3wrgklctzmiaton0P5Rr0efiaGAzyScpqGmtKMTX4m2HhJh3Kalv4BqrRgmDsZGzLcWw/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;">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="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMx9yReibpHJNVMvB4RK0ibylhqJV98X8KPzyuDoGR91TqrCvRqWORseRvyAxNs4lZj72RITRTgeV1Kg/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;">微X</span>：blwjymx2领取练习课件</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;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/rsVOmqahQG2qmwem3aaV0rPAvnpEurHH2qpvdBuBKE0QIjPlNkjEcHkbWib67hjjzvrILvMiaVAbkcgnKWQicYOvQ/640?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></span></strong></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;">↓ 点击<span style="color: black;"><strong style="color: blue;"><span style="color: black;">阅读原文</span></strong></span>，可直接购买。</span></p>
祝福你、祝你幸福、早日实现等。 你的见解真是独到，让我受益良多。
页:
[1]