l14107cb 发表于 2024-10-2 14:14:05

[office] 怎么样在excel2019表格中创建数据透视图


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">怎样</span>在excel2019表格中创建数据透视图 </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>是交互式的。在excel2019表格中创建数据透视图时，数据透视图的报表筛选将<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>已有的数据透视表创建数据透视图。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">　　1、<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>“Sheet1”工作表，单击【<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-axegupay5k/e1b8924f65a34910a8fe59acb08cf7b3~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=%2ByHW05pTSSYJgKshGZAOaMmUjWw%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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">　　2、弹出【创建数据透视图】对话框</strong></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/c566c7f130cc4e2d9ae54913bc0d7a8e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=zKjglUhR5Gq%2F7eb21fYowIs7TNQ%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;"><strong style="color: blue;">　　3、设置数据源</strong></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>A2:C18单元格区域来<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/ca51deb68813405f9ac6e7305cb9c32d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=nNfyjRqPbQICy7T2MHIUMRJvYOg%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;"><strong style="color: blue;">　　4、设置<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><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/655adac729bf42548be92254c776adc8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=orvfPCdouCdABfSmWwUrU9x%2Ff6w%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;"><strong style="color: blue;">　　5、弹出数据透视表的编辑界面</strong></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/59d9bb1d2afc45fe8f2bed261b405c5c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=j4HDusFce213R1IHXQK0BLfW9Dw%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;"><strong style="color: blue;">　　6、添加字段</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/5d53d68b00144a73b6a9d07d4635745c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=oSKvkY4jlAO%2BvDT0nxFx7OPPP80%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;"><strong style="color: blue;">　　7、查看效果</strong></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/b555a5fc8f374d9295e74aef6b5d3c04~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976083&amp;x-signature=XiQKwNDx%2BNS3ymK40hRjMXF7BRk%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;"><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>




nqkk58 发表于 2024-10-8 12:47:00

百度seo优化论坛 http://www.fok120.com/

nykek5i 发表于 2024-10-24 00:04:43

我完全同意你的看法，期待我们能深入探讨这个问题。
页: [1]
查看完整版本: [office] 怎么样在excel2019表格中创建数据透视图