这般的透视表你敢给领导看吗？Excel数据透视表实用美化技巧。透视表行标签都在一列中怎么样处理？不暗示归类汇总和总计行(列)
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIFvG59up9afHbhWDeCicL2qsPxAicLTfUNicgLlXnPPficOPbDz21vEoXknhMBf6DHZicqz30ODvNFNZWw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">Excel2013数据透视表入门教程</span>第3-3节 数据透视表美化-布局<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;">excel小课堂(ID：excel-xiaoketang 长按复制)</span>试试吧！</span></p>01<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>后的格式。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIFQ8j92vpzVSO5ZJwLibpUet8fhmflOvficrYovZau9zeoN6eXVECdLqOkUwiadicUPiaGRsS8m0m1Br7Q/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>02<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>-数据透视表，在弹出的数据透视表创建向导中，设置将透视表放在新的工作表中，创建一个初始的标准数据透视表。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_gif/GCEv3IwJAIFQ8j92vpzVSO5ZJwLibpUetBo4w5E1q8z1ia4NF2EyFBNYicvM0IpuQLqzdXaD7o5xoeu2whgRGlJMg/0?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>03<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;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIFQ8j92vpzVSO5ZJwLibpUetGYx9Eor9E5Al2p3cpr1SJicQj1WVX1KvWkVVPKxHy6kjxLj7ROsvllQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>04<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;">第1</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;">excel小课堂(ID：excel-xiaoketang 长按复制)</span>将在本文的末尾进行说明。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_gif/GCEv3IwJAIFQ8j92vpzVSO5ZJwLibpUetYKzwibcLM6cXvF5nMpEa9lPCtclCPAXNop91VtjBz4jsGZlp1JwhJsw/0?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>05<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></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 style="color: black;">归类</span>汇总</span><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 style="color: black;">选取</span><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></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz_gif/GCEv3IwJAIFQ8j92vpzVSO5ZJwLibpUetPTzWIiaic4iabFyekhgsDwK8vMSoIvDegibnmzOWibCu7hPSR2Mljr6zfjw/0?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>06<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><span style="color: black;">怎样</span><span style="color: black;">掌控</span>总计的<span style="color: black;">表示</span>呢？<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>07<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;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>08<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>，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>吧！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">点击下方“阅读原文”，<span style="color: black;">更加多</span><span style="color: black;">函数精彩视频教程</span>等你来</span></p><span style="color: black;">关注</span><span style="color: black;">excel小课堂(ID：excel-xiaoketang 长按复制)</span><span style="color: black;"><span style="color: black;">微X</span>号，</span><span style="color: black;">学好excel，<span style="color: black;">加强</span>职业素养，<span style="color: black;">提高</span>职场竞争力，升职加薪<span style="color: black;">再也不</span>是梦！</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">
我们有着相似的经历，你的感受我深有体会。 你的话语如春风拂面，让我心生暖意。 软文发布平台 http://www.fok120.com/
页:
[1]