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;"><strong style="color: blue;">全套Excel视频教程，扫码观看</strong></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 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 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><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;"><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;"><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;"><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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVPs5VU2sMIaWnDbeLw4Os3e1WjdZKOonicBiadIrdQib6gicSKNjHKgOaIg/640?wx_fmt=png&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;">这是一张12年的<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;">很显然这不是一个成功的图表。图表目的是想表达12年的<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 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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVOAaniaWkFAHC9Rr05277uf5T3GFiagGcPzOWH1iabf6fYUr1ZUHFqxIaA/640?wx_fmt=png&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;"><strong style="color: blue;"><span style="color: black;">渐变折线图</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 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;"><span style="color: black;">（1）选中A1:B13数据后<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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pV53MxcmNOpbUYFSKqcqXhrfw4p5CheNYUt6dR3h4j13oick5ibb4WbibJQ/640?wx_fmt=png&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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVvSGOyNqEOrRfowH1scRXIr4kffSwtBeXkEGG7CumZicSFckESoibSrmA/640?wx_fmt=png&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 style="color: black;">选取</span>“设置数据系列格式”，打开“设置数据系列格式”窗口，填充颜色设置为渐变填充，宽度设置为4磅，<span style="color: black;">同期</span>勾选窗口最下方的“平滑线”复选框。（</span><span style="color: black;">注：<span style="color: black;">倘若</span>需要精确看出各年份的细小变化，则不适合勾选“平滑线”。</span><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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVTP5Rtu4Libo5YYChIO8WeOmmOAtgJvJB1MFDiamv1BB0xcQxfFDN4R7Q/640?wx_fmt=png&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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVfntwBgaPWSwqtZ8bXN7TEKEhaPsYBDZQrJYkmghH98Evia1JCadd2ZA/640?wx_fmt=png&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></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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVu5VJMrswib6kibYpv3zTYnsuib10mC77MiclJntib1GtFBaRMg85hwr7ShA/640?wx_fmt=png&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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pV5dtHeTLhx7DXoQibgzGgoibxgyuqlVj3HRcGz6fSKPAGNCO4WK3NVFjw/640?wx_fmt=png&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></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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVJ1Kqiaw13nmrKydjZJ9HI1lIX26hpG8QFb9UnVtDbcUic3tNiaTULHibHw/640?wx_fmt=png&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>更加清晰明了地看到总体爬升的趋势，12年间<span style="color: black;">仅有</span>2年有<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/k6kCsib3eJMxYiaUTibKxayz7StMdJ512pVictDEPDME8Cg39ibcYOiaqyuGMPKddtXOxxaLFkzhhysnq1WdX4s3wia6w/640?wx_fmt=png&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;"><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;"><strong style="color: blue;"><span style="color: black;">添加号主<span style="color: black;">微X</span>号</span></strong></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></strong></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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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_jpg/k6kCsib3eJMziagcFmeEFMgLwxTB27P5Pic3ylmNhMOCAIpp310IIAlwcjH7baXbtfWA9bu4diasRPq7Kf2GTDTlKA/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;"><strong style="color: blue;"><span style="color: black;">微X</span>扫码观看全套Excel、Word、PPT视频</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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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/b96CibCt70iaajvl7fD4ZCicMcjhXMp1v6UibM134tIsO1j5yqHyNhh9arj090oAL7zGhRJRq6cFqFOlDZMleLl4pw/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_jpg/k6kCsib3eJMyxYWy5ZD6pDv0oQLbOmhoG8iabzibvAXCicqbhnrOYWxsZT7pdgVFERNFVFuuYSzSqsYqMas3EwM6cg/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/z9433rAGTDd78cwaDvzakb7575ic82NHaKASbJ2j330Auic2Ft9xA6W1fIhzeWib47ju2MNkhofiaumYKD9YltcqTQ/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;">爆文<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;">被鄙视</a>不会数据对比表达？速用Excel旋风图表敲晕他！</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;">为么</span>同事做出来的Excel图表这么好看？【Excel教程】</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教程：17集Excel函数公式，滴答老师主讲！</span></a></p>
你的言辞如同繁星闪烁，点亮了我心中的夜空。 你的见解独到，让我受益匪浅，期待更多交流。
页:
[1]