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>要算某个区域的采样点数据时,并且这所有区域都是在一张表格里面,<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/82a72e36298f4c9aa032c118b938ae96~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=Nb1qRAI7M7RVtLQSP99FpMNCRlM%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;">1、 <span style="color: black;">首要</span><span style="color: black;">咱们</span>选中你需要透视的列,如下图所示:</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/98509b364a864d5abb516c2365c662cb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=NQNpd5Esz9N9o1%2FFRAecai25tGc%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;">2、 <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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3、 之后<span style="color: black;">咱们</span><span style="color: black;">选取</span>区县<span style="color: black;">做为</span>行标签,在区县前面打钩,如下图所示:</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/2a47331215c54e379865e9c97dd6079f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=ZT%2BXVcMw%2FtVX2scW3Dt6Dise5Fs%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;">4、 之后<span style="color: black;">咱们</span>就<span style="color: black;">能够</span>进行对采样点计算;</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">(1)、<span style="color: black;">首要</span><span style="color: black;">咱们</span>把采样点行标签拖到值里面,如下图所示:</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/96fedffc90254400a0d6c9e9d2a0f57f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=WAs0D4nHfgjpJurmuQJZnMpTP1Q%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;">(2)、<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/80212511cb704850a04f557b122958a1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=ydZWMJqsv%2BsbHRo%2BYyjOroULSTk%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;">5、 <span style="color: black;">这般</span><span style="color: black;">咱们</span>就<span style="color: black;">能够</span>计算出区域的总采样点,如下图所示:</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-twdt4qpehh/2452d5cbf62f4711bf7d7851d961039f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954085&x-signature=UuEkw9tniUsLFKRsatVMqP3%2F9%2Bk%3D" style="width: 50%; margin-bottom: 20px;"></div>
论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上,我们要把这种精神传递下去。
页:
[1]