彻底解密EXCE数据透视表之十二[数据透视图]
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">彻底解密EXCE数据透视表之十二[数据透视图]</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）数据透视图VS普通图表</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;">
<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;"><strong style="color: blue;">数据透视图</strong></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;">数据源</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;">单元格中的数据</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;">不支持X、Y散点图、气泡图、股价图等。</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>
<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;"><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>
<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>
<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;">从多个维度分析数据，挖掘场景维度的意见，<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>
<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">适用于呈现特定数据模式、趋势和关系</p>
</div>
</div>
</div>
<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;">数据透视图为<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">数据透视表上的四大区域（筛选区、列区、行区、值区域）与数据透视图一一对应，行区域对应数据透视图的X轴，列区域对应数据透视表的Y轴，值区域对应数据透视图<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/tos-cn-i-axegupay5k/41e715015db34bed8ba1028677e5ec83~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=W%2Bb8IMr5vjdrj7Ypk9ufsvtHBMI%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）数据透视图的结构</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/154d4d547be8465d8c92d87be06d872d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=imKFMWGbVqTJT3zTbql%2FzXSmUvg%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、数据透视图基本操作</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;">①<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;">Step1选中数据透视表的任意位置，<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/89b57ed2167546b989536278b2b0c8e6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=74U84PdSh80y8c6fMjvqh6UHoiU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step2 <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/441ac013458447d2a9bda94088cb7793~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=jIlCqfZhk8l%2FPLlrM3oSztDhUKs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/2d307df231d94187adecf2510e0d42eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=urPQqwyZt71upywtsHNGTuvd4Po%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">Step1:点击【<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/eeedce13df584ae681407ce51d54a846~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=3%2BWmDkQhOSzJfZA5WawGSTSOBe0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ba164e00170d43c585b8d9489707a9fa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=%2BRkiEu231UzjTHI7Pa3yq4Kvh4U%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/d872e61473174f1090c1e432ce5433a9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=qzncTkvCFAaetxwPw%2FsCxUgvynU%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）移动数据透视图</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>
<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/985603b078c84b41a673aa63c6baf20b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=E14Q9HM4XnqfDobfanXe%2BG0vyiM%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/c09a74662ff443649c37280a261db2bd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=wFfct3yQetGidWc5hjGHYt%2BGvhQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">②剪贴（Ctrl+X）->粘贴（Ctrl+V）</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;">③<span style="color: black;">经过</span>【移动图标对话框】移动</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step01:点击数据透视图的白色绘图区，鼠标右键，<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/a277225cf9fe425aa422f811411b7d28~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=%2FkuCUrpAqt%2FS22%2BsvJiGZkbRmT0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step02:打开【移动图表】对话框，<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/5388e9db65a74ef4b69917db23afb8bc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=ZQII4enYBXVV3Wh00c7Mk7cXtNU%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>存储单元格区域中的数据。</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;"><span style="color: black;">选取</span>数据透视图，<span style="color: black;">而后</span>按delete键<span style="color: black;">或</span>右键剪切（Ctrl+X）。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（4）更改图表类型</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step01:<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/f6e08d9d8e2b4c369a0d2379d13a6bd2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=359KHuRqXov0YyNPGbEjVO6P9c4%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>点击透视图任意位置，进行激活工具栏数据透视图上下文选项卡->【分析】->【类型】->【更改图表类型】</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0f72815d88ad4a0e86847ea929ecada2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=IOVKRdYA6eqfOsoQUqByypLEyn8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">。Step02:打开【更改图表类型】对话框，点击“折线图”。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/cc7c3cff98184fcb8a09ffb469a9399d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=xr1TYdHR3Ub617jNg4ADdGyfSIM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/1ef2b50da18f4ed59429a932520d025f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=IyDV2HyzsOuLpR6E6dWJ3329RL8%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）字段列表和字段按钮<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>
<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/c6654b64e64f40a1949f88d0ac681eaa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=%2BISSSatKW9uSs6f6AT4mgptiwb8%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>/<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/0086c6a13d5f40c9b79fd19eacd7cab8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=DqJc15wahBEJ%2BNyvreG%2FYMc4MFY%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>点击透视图任意位置，进行激活工具栏数据透视图分析选项卡->【<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/70b35866349942638b44f13e0b8a6c49~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=l8s5xFxU%2Bo4RLsvqp1FM1PzBYkY%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>字段列表】。如下图</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7da34acdc42f4a48b0fcd92fa6f73bad~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=ROXKWJ9kfA5SNxFKmKJTKAx3Mac%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）切换行列字段展示</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://p6-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/16b7f54757544b90b1b6c5c90c3f0088~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=q1%2BpcqgN0SOlokw8bVhu16alMvM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/4d53a1554f5d41f79a182c011d182a74~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=iScQX4NvsZVAJzYYsae0OQsCquw%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>数据，打开对话框：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6c176e7230844a39ac30d53d2d5cf7a9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=uxk0lXVRr2pKMkIvbutJsW4I0Mw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/56646a12c33246df81cc64269384c4d6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=VNQDayFngaIDKNWSq47dqPv9gs4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/0bb401480ec74c45bbccca90d378028b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=ESFFQjZx3n8Bm7ACCSN7FJCOfAE%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、数据透视图各区域元素设置</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（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>【分析】->【添加图表元素】下拉框进行<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>点击数据透视图右侧“+”激活图表元素快捷菜单进行勾选。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/36ac75f308174f8e9df7349fd5933ac6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=Fq%2FOQ9PrwoLdtUGsBDX5KGjzraI%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）各区域元素的形状样式</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>【形状填充】/形状轮廓/【形状效果】设置样式。</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><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/07986b628b1d4592b091552c7e9d7b5d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=RKCtuciAmNBDJNUW7TdDupCsJ1U%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">Step01:点击【形状填充】，<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/af72222974354894b14d8c27c4cc4144~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=V4e2oyHDvwilM6AtqXgdmLDZ19U%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step02:点击【形状轮廓】，<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/f2f47ba31bca431090e2f56b07670abc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=yJgAeomtggSF%2BUPKenqKOB6jlfo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step03:点击【形状轮廓】->【虚线】，<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/b47cddc657594e3a85cf5d3b14d1357f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=q7zRY4ODyPucnM%2FkQ%2FJv7UnwkzQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step04:点击【形状轮廓】->【粗线】，<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/8b25dcfdde67453e838dab695b271c62~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=vg3bsDMZ6aYkbYGHS%2Fbj0rKrUGA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/c327e21fac0c467c9be1cda352a606bd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=NOeHjh2YfBaV7RT9PefLS2vXquE%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）设置图表标题</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><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/7429e70d7da94a6289e45795cfef9740~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=rZwhtQpDCdlXxa8k90DS%2BFi2svw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/290845396c0947eca4e8274c3a287c6a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=8fiN1lWK6pfwK7mnepRdDTpJ2%2Bs%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/a5142e280706472282f3bc15128f7819~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=3RzZsAHzIrVVC6MzjskVjDThmes%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">参考（2）。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（4）设置图例</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/7bada861c0c74142b6f3fbd4ead8d3b5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=IZ76jbzjFUUnLj%2F8vODyWsA7VJ4%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://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ad3d8ef6d089483c81dc7d096b71d64e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=06O1NDc8%2BMZHhgVhG4nz%2BwJVKGc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">eg:点击选中任意数据标签，<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/324b2c50d1fe4f54b433b7601b335b5e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=spu0qV60YpfHeV3EDzf2HpLDlOc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/cb7ee23c42e74782b3eae7ae7d0f293e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=F%2B2DDgo6XD20sFd36tiR8Zhe5WM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格中的值，系列名<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>
<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;">设置效果如下：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/979b88edadb84e68ad0e6a69770d2b00~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=TrOhkD%2B73I9PGdbFdoxP8pcPyNk%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）设置数据系列</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;">②点击任意数据系列，在右侧【设置数据系列格式】对话框设置。需要关注序列选项。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e35fe81cf53347d99674096a0da58054~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=faHxvtqkIVrhXm5U5ndKI4QjO%2F0%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/c54ce32c780a4e0094b4e4eee87d6572~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=VopiWVz81xvngjeIJxHbVsnUF7E%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）设置坐标轴及其标题</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>标题右键->【编辑文字】。</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>标题区域右键->【设置坐标轴标题格式】。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3848499fc0e0453392cc9a5de97b9bcb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=wqbeRcd14e8Ibze0shXt4t%2FUIlg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>
<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/e77d4217689a45d4ad1bd2a9fa0f87ec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=iiV9LAXQuSqQIlTMpLLp315u3sE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在坐标轴格式对话框的中，设置“对齐方式”的自定义角色修改为45°，</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/61e31f24f6e44c4d989a65d36346737b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=cCwAonA%2FLhBR9oEGbgOYfcSzK84%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/494ea5c73cf24be58c8219bb1f68d72f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=I8f%2FJEOx1WhLHUjuJr0AbABZSH8%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>数据之间的差异很大，不是一个数量级，为了较小的数据直观展示出来，<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/69cc341bbf0e4a308ddf11b2614a949c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=GSgugUI1qrUWIQ0ybeUml%2FAyAKc%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;">（8）设置数据表</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;">第1</span>小结，效果如下：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c34bd051e6374d72a6f424418a7802eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=cAfjPs2ay0cDyN203yM1H9rYqrQ%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）设置趋势线</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/a86a7679cd7a43b68e1ddb037e614617~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=CEQsg%2BhHO30f6QLDwamQr%2BqTx6c%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、数据透视图高级设置</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（1）数据透视图转换为静态<span style="color: black;">照片</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step01:选中数据透视图，鼠标右键->【复制】，</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step02:<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/8105299d533243a3be4077fd86d77fa5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=%2BN6W6kp8QDdvlDFZyYAp6sRnFbc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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/abf980a915ab4df6910ba02f4e5e0ac8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=8wrILhx3Ksz8rsA3DsY0J1X48VI%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）数据透视图模板创建和<span style="color: black;">运用</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step01:点击数据透视图的图表区，<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/b4a82b51385f4cdebb4b01a298bf6854~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=fkx%2BW0x69xK7AUSXOaSh%2F0F%2Fyy4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step02:打开【<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/ecea7f3f2c5f4d88b611586f88b6cc6e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=d9iRHPM%2FHHZ9lIK9IRUZ9coCsyI%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>了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/235b4cd9aab044a891fcb5a5b8c9dcaa~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=feW66sWuyFUJ9BpKb2tLSQ0H41U%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）快速布局数据透视图</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/1f8666b778824277ae1e3da5392cb66b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=Eys81YAQHkWqLXmK7Yp%2F7o9xFHY%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>合适的图表样式</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step01:<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/2e55badcd7b54f7180d5e436e8b36dc6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=BDV737EyvYRpCtxxgBKmbI8GW9k%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Step02:点击右下箭头，打开默认样式框，进行样式<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/fd431814920a4facab4f6fda044c033b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727975905&x-signature=5S8GWkMuPuqmyOVmqSXfZWYCoOM%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>
<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>按delete键将其删除<span style="color: black;">就可</span>。 <span style="color: black;">办法</span>参考上一大章节。</p>
你的见解独到，让我受益匪浅，非常感谢。 楼主节操掉了，还不快捡起来！ 你的话语如春风拂面，让我心生暖意。
页:
[1]