EXCEL二分钟，制作一个营销分析图-天涯论坛

1fy07h 发表于 2024-9-2 00:02:14

EXCEL二分钟，制作一个营销分析图

<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">作者：祝洪忠 <span style="color: black;">转载</span>：Excel之家ExcelHome</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>分析图表的制作。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">先来看数据源：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/e3947d909f384f84af0827bde28067e1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=kRZbPVexXIWNQc6%2FVc%2FKa2Cbyjo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">再来看<span style="color: black;">最后</span>的图表效果：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c62caa175ebd435793bc782beb464ea8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=uzN8%2ByCxJJa6ZzB6fDNjZ12hcfk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>占比<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>比例。</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><span style="color: black;">详细</span>的操作<span style="color: black;">过程</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>1</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中C1:D13单元格区域，【<span style="color: black;">插进</span>】→饼图。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击图例项，按Delete键删除。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/41c6ec866fe64ccd8c36ed8b8d0154ab~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=3fclUeRR2BM85ivhCb4BcbIvLHo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>2</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中B1:B13单元格区域中的季度总额，右键复制，<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/7ff1cee65214492d9c7e9f3b8ec86bb6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=6G6PWpSOSCK1lZI7jOQSwjSc%2FWs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>3</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">右键单击图表中的数据系列，更改系列图表类型，将“<span style="color: black;">营销</span>额”系列设置为次坐标轴。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/e054da8d24b0454c9e971901011f25d7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=YonLYtQCiuhJ1XzIyvidzM8ltXo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>4</strong></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>单击右侧的【编辑】按钮，轴标签区域<span style="color: black;">选取</span>A列的季度名<span style="color: black;">叫作</span>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/b542c6d7c2f34193a92fcbd0a0bffbf6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=0%2BihClFhPQKan6eZs9gKi%2FuA7P8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>5</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击图表中的数据系列，按下鼠标左键不放往外拖动。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击一下图表外侧，目的是暂时取消数据系列的选中状态。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">再次单击一下图表中的数据系列，继续单击选中其中一个数据点。</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>不成功，<span style="color: black;">能够</span>多练习几次，找找感觉）</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">依次将各个数据点拖动到图表中心位置。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/4875f04faa05455789c7c516f0f90f36~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=fYmtG0S97I5hKCkj3pkAXF1erQ8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>6</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">右键单击图表数据系列，添加数据标签。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">设置数据标签格式。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/ad3edd6ef1a64e88b86d8e112f68f727~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=laxrCIsoN%2Fh%2BgJW2fMFcGjs01Mc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>7</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在设计选项卡下，更改图表颜色。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">而后</span>设置数据系列标签的字体颜色。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/f4ea4b995b1e4ed8b70b1086051056b5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=VRYGbE2mY%2FIq67vHGlnn0KxK9as%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>8</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后添加图表标题，OK了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/142e39da6f42499bbc234af57a935720~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=tZLy9z7MTsYQY1SD47G7Trw4Vfc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>变化，咱们的图表就会自动更新<span style="color: black;">表示</span>效果：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/f036b83dcca34d8fb7a5918df6e80cc2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725808792&x-signature=41jxfDmHW6ADnKzD1UC5u1k3EAM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>试试吧。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
   <div style="color: black; text-align: left; margin-bottom: 10px;">
         <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="http://p1.toutiaoimg.com/large/mosaic-legacy/b72300027b8e01398b03" style="width: 50%; margin-bottom: 20px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
            </div>
            <div style="color: black; text-align: left; margin-bottom: 10px;">
               <div style="color: black; text-align: left; margin-bottom: 10px;">Excel 办公常用小技巧</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel小技巧</div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">
                     <div style="color: black; text-align: left; margin-bottom: 10px;">39.9币</div>
                     <div style="color: black; text-align: left; margin-bottom: 10px;">1,696人已购</div>
               </div>
               <div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
            </div>
         </div>
   </div>
</div>

流星的美 发表于 2024-9-10 14:20:32

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

nqkk58 发表于 2024-11-12 01:44:07

楼主听话，多发外链好处多，快到碗里来！外链论坛 http://www.fok120.com/

页: [1]

天涯论坛's Archiver

EXCEL二分钟，制作一个营销分析图