[office] Excel怎么做企业开销汇总的数据透视图-外链论坛

219mze 发表于 2024-10-1 17:14:22

[office] Excel怎么做企业开销汇总的数据透视图-

<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel怎么做<span style="color: black;">机构</span>开销汇总的数据透视图? Excel怎么做<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">平常</span>工作中，Excel常伴<span style="color: black;">咱们</span><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>却很少有人用过Excel做数据透视图，本经验给读者们讲解<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-axegupay5k/ea73d71de97d4522bc7fa294b7f985b7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=9wU%2FWVko5wkHzRCvDtb6Na0Eg%2FI%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、原数据表如下图</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d821594107884feab6c5f6da1110928c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=tJLCEbv3%2FC3M3V%2FD6x0BGQ9FEKo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<strong style="color: blue;"><span style="color: black;">插进</span> - 数据透视图</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2fb4b0dd34af41bd93984b668a384faf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=lS%2BKfsV24TB3R0DOxGQNC6MFNew%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、<span style="color: black;">选择</span><strong style="color: blue;">数据透视表/的<span style="color: black;">安置</span>位置</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/88f39671fcec47139b8634d000f49a18~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=htEpaePskBGBCnIad2fzZd1qev8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4、<span style="color: black;">插进</span>后的效果，<strong style="color: blue;">一个空白的数据透视表区域和数据透视图区域</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1a4cea769e1f4b81a5a90812aa874029~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=Egi4n0WWcqhUFW%2B27GrPfS245Kw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5、点选数据透视表区域，在右侧的字段列表中选中所有月份。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8af4fcafee79421aa7fde49e8a5ce8b8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=2FytsYTcgCtXAz8Fly7wok8KemE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6、<span style="color: black;">查询</span>“<strong style="color: blue;">求和项：”，</strong>替换为 <strong style="color: blue;">“ ”（空格）。</strong>把月份前多余的文字去掉。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3a8c49b5495c424fa1abcc2204828378~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=cwkdGQOWQA3orFyVyCeaCJ0Dq%2Bw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7、<span style="color: black;">选择</span>数据透视图，<strong style="color: blue;">设计 - 切换行列、修改图表类型、<span style="color: black;">隐匿</span>图表上的所有按钮</strong>。结果如下图所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/00551fed024c4ca7b41ddde0a9412eb2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=WeJbr1wxkyI0uHcg0cHZ1oUtI6k%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">8、<span style="color: black;">插进</span>切片器（只适用于2010版和以上版本）</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aed1016b282648edb3f1f2e6b2f5f92b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=Yfoue2%2B0NkulUMdMbJfLed7%2Fh7o%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">9、<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-6w9my0ksvp/3ee82cede6724ed294b6429d28e43b02~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=SA3qRKWwgewcpf6c0jZCidN5eXQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1d84326ad25845968cf5fe56359aa5eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976438&x-signature=yyxra2p3dvIIuz02R4hqwbmHNAs%3D" style="width: 50%; margin-bottom: 20px;"></div>

nqkk58 发表于 2024-10-17 03:01:25

你的见解真是独到，让我受益良多。

nykek5i 发表于 2024-10-21 15:54:39

感谢楼主分享，祝愿外链论坛越办越好！

4zhvml8 发表于昨天 14:29

说得好啊！我在外链论坛打滚这么多年，所谓阅人无数，就算没有见过猪走路，也总明白猪肉是啥味道的。

页: [1]

外链论坛's Archiver

[office] Excel怎么做企业开销汇总的数据透视图-