动态图表的制作——（1）数据透视表
<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>在<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/tos-cn-i-qvj2lq49k0/16d678010a2e4930bbe651930828da95~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=DfySE0bZYEOgvPYtW3VWUkuKtyM%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">动态图</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">知识点：</strong>接下来，<span style="color: black;">博主</span>就和<span style="color: black;">大众</span><span style="color: black;">一块</span>来学习制作动态图表，制作动态图表需要<span style="color: black;">运用</span>到三个Eexcel技巧：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1）数据透视表</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2）切片器</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3）透视图</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;">1）数据透视表的制作：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.11 <span style="color: black;">首要</span>打开一份带有<span style="color: black;">营销</span>数据的Excel文档。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2a00afe8fc6a49d480ebd1a89616185a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=5rdloLnaFvK29onSFTs%2FMx2zTlg%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">带有<span style="color: black;">营销</span>数据的Excel文件</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.12 基于这份口罩<span style="color: black;">营销</span>数据，用透视表功能做快速统计，请<span style="color: black;">根据</span>下图指引创建你的<span style="color: black;">第1</span>个透视表：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/cabf16fb96ea4b06abc9bd812c2fd60d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=xn3Qh%2BO9qFo05fiz6nd6QdHQDxE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.13 <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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/1f2a7c2af80847fab837a3a028ef7f05~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=YDk7Tiyjg6qI4J%2FIDqhVVzLGyP4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.14 在“学生操作区”这张表格中，点击C11单元格（第C列第11行），<span style="color: black;">而后</span>点击弹框的确定按钮。如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/3ce97d47e0bd44a88c5d3537ffee7d73~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=c3Q4BymmYQJKzX939Kvb41%2B79Vg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.15 <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/tos-cn-i-qvj2lq49k0/2fe962de87684869801e53ec28850ada~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=yTv4xQbdF%2BXFlGn8iMuvm85TrCo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.16 关键操作来了，在屏幕最右方调出一个小窗口“数据透视表字段”，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/689234eac5a5454490b00f60e7d6eca8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=VwhsPfCyfoH5pe3gI6m%2BjQFyGCY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.17 “数据透视表字段”窗口上面有这批<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/42d5f2753cf749838a63447a78488d1f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=jxU0FVFwwDKWxSwnBRrqjMVHxl4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.18 <span style="color: black;">此刻</span>，<span style="color: black;">咱们</span>查看下透视表标题，<span style="color: black;">发掘</span>它默认第1个标题是行标签、第2个标题前有求和项：的字样，如下图所示。<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/tos-cn-i-qvj2lq49k0/62f1779115f140dc98b42bca8dc1e00b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=05u%2F2jF4xWrw8e1K7u%2F3Q5MesGc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.19 超级简单，<span style="color: black;">咱们</span>直接双击标题所在单元格进入编辑状态，<span style="color: black;">就可</span>重新输入。如把C11标题由“行标签”改为“<span style="color: black;">制品</span>类别”，如下动图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/3419f240c1d9483193823cb5670220d0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=a9HZdyzAz3i%2BebwcHp1Auz9AmWQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.20 <span style="color: black;">一样</span>的，双击旁边的D11标题单元格，<span style="color: black;">区别</span>的是<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/tos-cn-i-qvj2lq49k0/81da75693bf64688af9c22140d508fec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=6FohhTL0lGzzGhNqzpwRBNOERCQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.21 为了展现<span style="color: black;">每一个</span><span style="color: black;">营销</span>员的金额汇总结果，<span style="color: black;">咱们</span>需要再多一个数据透视表，点击数据透视表任意部位，按键盘Ctrl+A全选<span style="color: black;">全部</span>透视表，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c6e94479a6cc44b798970abef4ad96c6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=14tb8g0SqhcxUCBbip0bw9LHH3c%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.22 按住Ctrl + C复制，电脑会自动复制这个透视表，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/831b737d62c8443fab51f7c846d3a3f8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=tSxwIwqAyJ2zl5PcFpRdYk0pfes%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.23 将原有的数据透视表复制成2个，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/670656a0542e4f9c908cb0d262e8f75c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=GaFD%2FlxpkGg6wOyJ%2Blm4mVHxJAA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.24 <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/tos-cn-i-qvj2lq49k0/fb6bd0c711b242d1ad4e000c6098f0ee~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=OqqNNz4uux%2BrciFIurdDbPaXoB8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.25 <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/tos-cn-i-qvj2lq49k0/1c70f6b8fb7047f7981d2cb91c090d7d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=biw8FDL6MBjGiWxIe5cdfrnJPMA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.26 <span style="color: black;">这般</span><span style="color: black;">咱们</span>就成功创建了2个数据透视表！如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5f4d2108599c4cdea5836c0ff9c72407~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=MmomJuXWMXANZYCECRjFXqgINmU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.27 接着<span style="color: black;">同期</span>选中两张数据透视表，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/3f109ed9a31845de82e4bdf644d0b577~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=RHg4Sej5%2FmAPTD6QZiKjwnuS5QQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.28 为透视表<span style="color: black;">选取</span>一个合适的样式，如下图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/458b8f5dd38c4a0a8df262e65c15596f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953643&x-signature=HkcOEnym%2FKHisltmvfDj5K%2FjhBg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1.29 <span style="color: black;">这般</span>，数据透视表的样式美化就完成啦！<span style="color: black;">区别</span>的excel版本系统自带的样式模板<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>
你的见解独到，让我受益匪浅，非常感谢。 楼主发的这篇帖子，我觉得非常有道理。
页:
[1]