EXCEL折线数据透视图制作
<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>点击切片器，让折线图动起来。<span style="color: black;">咱们</span>在开会，报告中比较<span style="color: black;">平常</span>。其实做法<span style="color: black;">亦</span>非常简单。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/8b08c18adeca4329813e5297fd2ea058~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=DvYG8KQonLXOOyh8M%2B4QPu0nCFs%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 style="color: black;"><span style="color: black;">第1</span>步，准备数据，楼主做的是某文具<span style="color: black;">机构</span>2020年<span style="color: black;">营销</span>数据表。（数据为虚拟，只为展示）</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/142e836e8895413db8d342af8c15d104~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=Zp9%2FXZHHwmHufGRhQxSddHJ3GZ8%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 style="color: black;">第二步，<span style="color: black;">按照</span>数据源做数据透视表，做折线图，<span style="color: black;">咱们</span>需要时间和<span style="color: black;">营销</span>额两项数据，做透视数据表<span style="color: black;">过程</span>，前面笔记有介绍。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/36f167c821be4da288a4032661447cf2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=ci%2BcxF8kVXxUEZIGtgyEBolpK%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;"><span style="color: black;"><span style="color: black;">第三步，点选数据透视表任意位置，<span style="color: black;">选取</span>工具栏<span style="color: black;">插进</span>，<span style="color: black;">选取</span>折线图。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ac2703d75d294fed81cfa5b7851012fc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=lJWKzmbNjHOqUfehmiLrGORWkyY%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-qvj2lq49k0/337aabf54beb491c991ebad9acc95fb6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=fkAClkHCX66zBap6ZIFIOaKtAkY%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 style="color: black;">第四步，为折线数据透视图，加切片器。点选数据透视图，点击工具栏<span style="color: black;">插进</span>切片器。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/093b0a8695f342338ecc76a84c10741c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=SSqwoiUgKIwzlK4wJ5TDpiED%2BFc%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 style="color: black;">在弹出窗口<span style="color: black;">选取</span>需要的筛选项，楼主<span style="color: black;">这儿</span><span style="color: black;">选取</span>的是商品品类。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/1a2c57ea11a9403591b48ff5a8897dc0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=Hkjl6bv%2BPdC%2BfKzSP0kUlbovVr8%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 style="color: black;">最后<span style="color: black;">调节</span>设计，数据透视表，数据透视图，切片器为统一风格</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/67936513cb7540d2adc283c9301ebfc2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=NFbFHdgZBNNoU8nfR0A8zdHw9Mc%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 style="color: black;">⚠️（图八，图九）为<span style="color: black;">最后</span>完成图，点击切片器，让折线图动起来吧。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/d1e4469e0a8547f2a98f0377b89f14bd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=0AyB5JkYSJj7h8hFCp5GikffZlQ%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-qvj2lq49k0/cea263a351144cb0a98a708d922d46b8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975919&x-signature=AxknicIHh%2FKWMOXzUTPBKn0m28g%3D" style="width: 50%; margin-bottom: 20px;"></div>
这夸赞甜到心里，让我感觉温暖无比。 顶楼主，说得太好了！ 我完全同意你的观点，说得太对了。
页:
[1]