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>数据透视图的最大好处是，它<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>主题。本文对数据透视图进行了深入分析，涵盖其定义、在 Excel 中的<span style="color: black;">运用</span>、其功能以及其他<span style="color: black;">关联</span>主题。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">什么是数据透视图？</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">数据透视图是 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><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>您与数据交互，从而更<span style="color: black;">容易</span>地<span style="color: black;">发掘</span>见解和模式。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">数据集简介</h1>
<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>在 Excel 中创建数据透视图的过程，让我向您介绍我在本文中用于创建数据透视图的数据集。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b19c48d92f3243519f3d05663a4249d7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=xRwbzgKqKB52AzmGdbwLLkpaXGU%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>，并且此工作表中有超过 15,000 个条目。<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>数据透视图来代替。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">怎样</span>在 Excel 中创建数据透视图？</h1>
<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>。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1.数据源的数据透视图</h1>
<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_1：从数据集中<span style="color: black;">选取</span>一个单元格，<span style="color: black;">而后</span>按 CTRL+A。</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>_2：从功能区中<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>_3：单击“图表”组中的“数据透视图”按钮。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/79219bc1ec674fe98059df06e018ff73~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=mwJHioEE0%2BOdwM%2FnrfMUq%2BBtvB4%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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_4：在表格/范围框中<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>在 Step_1 中<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>_5：从“<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>了现有工作表。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_5：单击工作表的空单元格 J5。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_6：跳过复选框将此数据添加到数据模型。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step_7：最后，点击“确定”按钮。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d5e10fe8b81f4be5b86279ce6f787bd1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=8oz2k11RLpMC4RWc5cg0lTaC7SY%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;">最后结果</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/tos-cn-i-6w9my0ksvp/df1d26f1911847faa35e5f03497ebdac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=TT5cUxjI%2FaryNPuiy7lzUl%2Bm3ss%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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2.数据透视表中的数据透视图</h1>
<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a53ee55b7e5b476eaadc1a517ad09764~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=aG5PFszfCtm4zkzWePvfJKElVKc%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>指南</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_1：单击数据透视表内的任意位置。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">这将使 Excel 功能区中的数据透视表分析选项卡可见。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_2：<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-6w9my0ksvp/48264a682e5442b5ac76c579dd78ad7e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=E%2BslydOVxX0nBKAWFkgc54oKt7w%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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_3：从可用选项中<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>_4：单击“确定”按钮。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aba65b2f2d3441428eb6e95524e0a46a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=ZYWT8NMY2PWqlkl5PtnVfWAHX9U%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;">最后结果</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4a987080ad99447591bfd59a16b76df0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=wUZhMDlUtatBJdMdLsLBWKtTD0U%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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">更改图表类型</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel <span style="color: black;">拥有</span>一系列用于高效数据<span style="color: black;">暗示</span>的图表类型。请<span style="color: black;">根据</span>以下<span style="color: black;">过程</span>在 Excel 中更改数据透视图的图表类型。</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>指南</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_1：单击数据透视图将其选中。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_2：从功能区导航到“设计”选项卡。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_3：单击“更改图表类型”按钮。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/49e5d9c4f28f4b3da066d2cb7c4cac07~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=fIvQbl%2FMv9tKI2yTb4b2sVq1MPQ%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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">过程</span>_4：从可用选项中<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/aa268518bf934fbbb332725400012092~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=zWhr7hHoR4k2zvE79JDSc2n35%2F4%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>_5：单击“确定”应用新的图表类型。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">Excel 中数据透视图的功能</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在 Excel 中<span style="color: black;">运用</span>数据透视图时，<span style="color: black;">认识</span>数据透视图字段的特性和功能至关重要。数据透视图有一个数据透视图字段任务窗格，用于组织和<span style="color: black;">表示</span>图表。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">A. 数据透视图字段</h1>
<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>在数据透视图字段窗格中。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1. 数据透视图字段列表</h1>
<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/tos-cn-i-6w9my0ksvp/d2552b7a5c6e476ea515d527e7386f1c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=D4unQ9ie3cEykxPSVTZtWLUJ%2Fks%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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2. 数据透视图区域列表</h1>
<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;">轴（类别）</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/tos-cn-i-6w9my0ksvp/e86a0d4727f44346a9b6c8dce2b8cfc3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=UTvXkxldzp4zA%2FU1yJwN1qDbJkk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">B. 过滤区</h1>
<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>或排除特定数据点。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3be855b18f2f48cb8e44accca6bdc19b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=HSZRbGnD6d2Rnpo5zmCvg%2F25zls%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/tos-cn-i-6w9my0ksvp/adfdadcf04074b1b858d49750a04d454~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=SQ5sRAGYUFvYXKvapyti2P5Lktw%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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">C.传奇（系列）区</h1>
<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>颜色的列。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2e9a12224cc644cdb2130c1ebd10fde6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=x%2FYz5U%2FDxf0RDBFwteIJEpxcWYo%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>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">D. 轴面积</h1>
<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>您设置水平 (X) 轴标签。</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> Excel 工作表的数据透视图的水平轴上。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e249c39a20c64e15aa3cc87c3a6ae38e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=In25ifdmQkMHMVLxLUCDQDc4Ijs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">E. 价值观<span style="color: black;">行业</span></h1>
<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>要在 Excel 数据透视图中可视化的数字或定量数据的字段的位置。<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/260898ae84a04f6daaee31367f75d0c4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=8W74hxtOKPyVqZvc2SST1Xv029I%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">删除并重新<span style="color: black;">表示</span>数据透视图字段</h1>
<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://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c706313243ff485b9566edd4f785f3d3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=ItOYbtkNqAWqTQtDrpGn1Ut5fCY%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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">要删除数据透视图字段，请单击数据透视图字段任务窗格右上角的十字 (x) 按钮。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5942195da0804fc6b74831e43fea19be~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=oPpTx05WOaXDmYK3jBzaF7Vshlk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">刷新数据透视图</h1>
<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/tos-cn-i-6w9my0ksvp/4703c2c38bcc41f593fa511bc7240b6a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=WnMsKNOuPVyQBBELdsdlXf%2FhVy8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">在数据透视图中<span style="color: black;">插进</span>切片器</h1>
<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>的数据。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3e61df8305a147ca83fb11646e534042~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=ogAib0fd%2ByDrsBgV%2BSDiHJbAl1k%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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/17da40d87e4b40458e38194058c0667b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=2hp9slSSrmT8aIwfCEfAc8JUfgM%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/tos-cn-i-6w9my0ksvp/fb7557af120b487684d448c1323f2d39~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727976455&x-signature=SSi7LgvXQ0ctjuzaXQizsGPQsvU%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>地关注特定的数据子集，而无需更改 Excel 中的<span style="color: black;">基本</span>数据透视表。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">结论</h1>
<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>
谷歌外贸网站优化技术。 百度seo优化论坛 http://www.fok120.com/
页:
[1]