u1jodi1q 发表于 2024-10-2 14:20:44

[office] excel2019中编辑数据透视图的办法大全


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">excel2019中编辑数据透视图的<span style="color: black;">办法</span>大全 </p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在excel2019中创建数据透视图以后，就<span style="color: black;">能够</span>对它进行编辑了。对数据透视图的编辑<span style="color: black;">包含</span>修改其布局、数据在透视图中的排序、数据在透视图中的<span style="color: black;">表示</span>等操作，今天<span style="color: black;">咱们</span>利用一节excel教程对excel2019中编辑数据透视图的<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;">　　<span style="color: black;">1、</span>重组数据透视图</strong></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;"><strong style="color: blue;">　　1、单击【季度】选项</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">　　在“Sheet2”工作表中<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-axegupay5k/8399a08dbc424cb39a87fd001c4b923c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=t5Ysr0cEkGevmC8dvEKnCucWpQs%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;">将【季度】选项拖曳到【图例(系列)】列表框后，<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/e853c29953b7447084f0d576dac13d1b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=VgI8hyF1vfAp8XKxse5DFeNW4PM%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;">　　<span style="color: black;">2、</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>需要，删除数据透视图中的某些数据，使其在数据透视图中不<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>“Sheet3”工作表，在数据透视图上单击【<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/618109089e804e43a633d36c7c1930cf~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=zF7ahI2%2FYgzsIQFV0XgfYGKqEVw%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;">　　2、查看效果</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>。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/592c5c1e49c94b0abf7c083d9693deef~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=JMiOAjFqpUSNlvhPLR0DQKpMmYE%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;">　　<span style="color: black;">3、</span>更改数据透视图排序</strong></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;"><strong style="color: blue;">　　1、单击【排序】按钮</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>单击【确定】按钮，<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/cc25d44d073542a3bed290189fd83a19~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=yTWyq3gSpQL4tbDlGZsJSMw%2Fmm8%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;">　　2、设置排序方式</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/cad506a52a144233bbf966c785c7f4bd~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=BGwBma0%2Fe1Ek3DR%2BM6SnpRZNp%2BM%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;">　　3、查看效果</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://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6680597352c440fbbd502d53329a8624~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727976636&amp;x-signature=o%2BkefVlPqHOvrXQlD%2BgDV8v6E8I%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>一共学习了3个关于在excel2019中编辑数据透视图的<span style="color: black;">办法</span>，分别为excel中重组数据透视图、删除数据透视图中的<span style="color: black;">有些</span>数据、更改excel数据透视图的排序3个<span style="color: black;">办法</span>，这基本上<span style="color: black;">亦</span>是编辑excel数据透视图的常用操作了。</p>




qzmjef 发表于 2024-10-17 08:29:56

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

7wu1wm0 发表于 2024-10-26 04:36:21

论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。
页: [1]
查看完整版本: [office] excel2019中编辑数据透视图的办法大全