论坛 › 内蒙古 › Excel怎么样制作手机端报告的图表？教你一招制作另类折线图！

5ep9lzv 发表于 2024-10-2 16:21:11

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/JwMPc9Sj4Q7l64c5tHKdmeG6b3YzfiapBialKUL7AQqdkcujbbNl9TlyWUmExOo6EJibPhL13gzKNQicV89WliaQlpA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><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>：芒种学院(ID：lazy_info)</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><strong style="color: blue;">移动端折线图</strong><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><strong style="color: blue;">移动端</strong><span style="color: black;">」和<span style="color: black;">「<strong style="color: blue;">PC端</strong></span><span style="color: black;">」<span style="color: black;">大众</span>经常看到的图表有什么差异呢？最<span style="color: black;">重点</span>有以下几点：</span></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">移动端的图表偏长，PC端偏宽；</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;">说了<span style="color: black;">那样</span>多，<span style="color: black;">那样</span><span style="color: black;">「</span><strong style="color: blue;">移动端</strong><span style="color: black;">」的图表大概长啥样呢？简单绘制了一个小案例，<span style="color: black;">能够</span>参考下：</span></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/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLZboJGwExUY4owZkzLCv5kf67UsAEm1QrvSfpuic2AbX7HmIEMSicuDlg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">例如在PC端的折线图，<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>问题来了，在Excel中，<span style="color: black;">怎样</span>绘制这种<span style="color: black;">「</span><strong style="color: blue;">纵向折线图</strong><span style="color: black;">」，其实很简单，利用散点来模拟<span style="color: black;">就可</span>，和小北<span style="color: black;">一块</span>学习吧~</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;">- 01 -</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">处理作图数据</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><strong style="color: blue;">纵向折线图</strong><span style="color: black;">」的原始数据，数据总共有3列，分别<span style="color: black;">暗示</span>月份、iPhone、小米MIX，如下：</span></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/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLSicZJc9ST5ElZ4Jvb5pmNfFQdhpsBtywKXRQUiaomKmuqSvvrUMRkVQw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">在<span style="color: black;">这儿</span><span style="color: black;">咱们</span><span style="color: black;">运用</span><span style="color: black;">「</span><strong style="color: blue;">带直线标记的散点图</strong><span style="color: black;">」来模拟<span style="color: black;">「</span><strong style="color: blue;">纵向折线图</strong><span style="color: black;">」，<span style="color: black;">因此</span>需要拆分出几个作图数据。</span></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 style="color: black;"><span style="color: black;">包含</span>：<strong style="color: blue;">两款手机的散点图、坐标轴模拟散点、两个图例散点模拟共计5个表</strong>，<span style="color: black;">详细</span>如下：</span></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 style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLEbDOBdSuyGQgySrbHbrW1gkuImQbZVmjxYdibVEiageXPe0pO2OctzibA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">散点图1和2非常简单，Y坐标从0<span style="color: black;">起始</span>往上叠加<span style="color: black;">就可</span>，散点图3用于模拟坐标轴，X轴<span style="color: black;">所有</span>为-3，Y轴叠加。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而散点图4和5是模拟<span style="color: black;">「</span><strong style="color: blue;">图例</strong><span style="color: black;">」，<span style="color: black;">详细</span>的位置<span style="color: black;">能够</span>细细<span style="color: black;">调节</span>。</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></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;">- 02 -</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">绘制散点图</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><strong style="color: blue;">散点图1</strong><span style="color: black;">」，<span style="color: black;">插进</span><span style="color: black;">「<strong style="color: blue;">带直线和标记的散点图</strong></span><span style="color: black;">」，如下：</span></span></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_gif/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLwOpgYTs9f8WYg12HibO70WoEic8hEybiaFn2KwM9uJLGm7RianaeStYxVw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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;">接着选中并赋值<span style="color: black;">「</span><strong style="color: blue;">散点图2</strong><span style="color: black;">」，点击图表，打开<span style="color: black;">「</span><strong style="color: blue;"><span style="color: black;">选取</span>性粘贴</strong><span style="color: black;">」，勾选<span style="color: black;">「<strong style="color: blue;">首列<span style="color: black;">归类</span>为X值</strong></span><span style="color: black;">」，依次操作所有的作图数据。</span></span></span></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_gif/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLzOqcNwJmpuia0M3YtChDSgEW8tHYgE1kuIgaKgu21RecBJGz4jeSv9g/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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;">将所有的作图数据绘制成<span style="color: black;">「</span><strong style="color: blue;">散点图</strong><span style="color: black;">」后，<span style="color: black;">此刻</span>图表长这个样子：</span></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/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLVr0Wrl4aSSRdVvC7zWGI61zLhkKQUgmcbC6hZL1rqsD4jOVquprxlA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">绘制好散点图之后，接下来<span style="color: black;">调节</span>下两个坐标轴的数值范围。</span><span style="color: black;">水平范围<span style="color: black;">调节</span>为</span><span style="color: black;">「</span><strong style="color: blue;">-5~23</strong><span style="color: black;">」，垂直范围<span style="color: black;">调节</span>为「<strong style="color: blue;">-1~12</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>将数值的最大和最小分别往后衍生1个单位<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLt9uLar3FZcqzBibv1mDkvYLrM9R3eGH04tYpVIrmMRkoOgx7lElmEwg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">看上去几乎<span style="color: black;">无</span>任何变化，接着<span style="color: black;">插进</span>一个<span style="color: black;">「</span><strong style="color: blue;">圆角矩形</strong><span style="color: black;">」，并且将它粘贴到<span style="color: black;">「</span><strong style="color: blue;">坐标轴散点</strong><span style="color: black;">」上，<span style="color: black;">调节</span>图表的高度，如下：</span></span></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_gif/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLNrCglMVFOGVYLYvvoKbfCg3BpBic17hIy5VC1a4hHjp0lS3fWFhonNw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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;">将<span style="color: black;">「</span><strong style="color: blue;">网格线</strong><span style="color: black;">」<span style="color: black;">所有</span>删除，为<span style="color: black;">「<strong style="color: blue;">坐标轴散点</strong></span><span style="color: black;">」添加<span style="color: black;">「</span><strong style="color: blue;">水平误差线</strong><span style="color: black;">」，用于模拟坐标轴，如下：</span></span></span></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_gif/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLEgzyOXuJ3ecHlKmGiasTkcgJ0BY4U9icwORfkW7fliaro2218HOmHC8wQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=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;">用<span style="color: black;">一样</span>的方式为<span style="color: black;">「</span><strong style="color: blue;">图例</strong><span style="color: black;">」<span style="color: black;">亦</span>添加单位为1的水平误差线，<span style="color: black;">此刻</span>得到如下图表：</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLO54x8ykeMEb3HicojYiaZ5zTjKfl2Rc2tg2MNXqX3ZpxXqvH20nBraZg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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><strong style="color: blue;">纵向折线图</strong><span style="color: black;">」的轮廓基本上就<span style="color: black;">已然</span>出来了，接下来将图表中的数据系列添加数据标签、脚注、标题、LOGO、配色等等。</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></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/JwMPc9Sj4Q5HClJ723O2OyjEfIiaGusmLkSN4ZhZk0SU8Kjz2ibNlMdpkKyKAchNspGKawIlMichcJOicfRibyoMkwQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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;">好了，<span style="color: black;">那样</span>今天</span><span style="color: black;">的技巧就分享到<span style="color: black;">这儿</span>了，<span style="color: black;">倘若</span>你还有其他关于 BI&nbsp;</span><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><strong style="color: blue;"><span style="color: black;">「<span style="color: black;">好看</span>」</span></strong><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><strong style="color: blue;">数据处理和信息图表</strong>的<span style="color: black;">更加多</span>思路与技巧？</span><strong style="color: blue;"><span style="color: black;">「Excel实战课，让你的图表会说话<span style="color: black;">」超值 Excel 课程</span></span></strong><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/JwMPc9Sj4Q57yfnsXldeeXkdMfocicMIh1EpP6L8JHviaRbwu5vlgpQ209Ax9JZPJNbExjTGVue942bMgNIjiazSQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;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> Excel 商务图表训练营</span></strong><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;">新课发布，更新完毕，作业打卡，5小时<span style="color: black;">作为</span>图表<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><strong style="color: blue;">仅需</strong><strong style="color: blue;">69 元</strong><span style="color: black;">，5小时共计58节课教你零<span style="color: black;">基本</span>学会制作<span style="color: black;">高挑</span>上的Excel商务图表</span><strong style="color: blue;">！</strong><span style="color: black;">

7wu1wm0 发表于 2024-10-26 00:43:29

哈哈、笑死我了、太搞笑了吧等。

7wu1wm0 发表于 2024-11-11 02:23:10

感谢楼主的分享！我学到了很多。

查看完整版本: Excel怎么样制作手机端报告的图表？教你一招制作另类折线图！