【Excel 教程 之 动态图表-8】数据透视图
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOB94mPlk39ZOTr9bT2jKiaZoXR80Lcv8gRkKHxI285SyNCj6X0c4qTDEQ/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<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></p>
<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>的话，<strong style="color: blue;">动态图表就<span style="color: black;">能够</span><span style="color: black;">得到</span>数据透视表强大的透视汇总能力，又<span style="color: black;">能够</span><span style="color: black;">得到</span>动态呈现的效果</strong>，岂不美哉？</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;">答案是肯定的，Excel 为<span style="color: black;">咱们</span>实现了将数据透视表转化为图表的功能：数据透视图</span></strong><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;">数据透视图是 Excel 2010 版本才加入的新功能，<span style="color: black;">日前</span>存在于Excel 2010，Excel 2013，Excel 2016 这三个版本。它<span style="color: black;">能够</span>将数据透视表的汇总数据制作成图表。</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;">当汇总<span style="color: black;">要求</span>变化时，数据透视表得到的数据是变化的，数据透视图<span style="color: black;">亦</span>会跟着变化，<span style="color: black;">最后</span>呈现出动态图表的效果。</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBdpGKF2OT4AaYJ8kFKrczSxQIibGRomu2fk1e8bwcBG2zxZQLiaSAsIhQ/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<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 style="color: black;">因为</span>数据透视图是 Excel 内置的功能，<strong style="color: blue;">它的制作过程<span style="color: black;">亦</span>很简单</strong>。下面<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;"><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 style="color: black;">这儿</span>准备的数据源非常简单，<span style="color: black;">仅有</span>两列数据：假设每行代表一件事情，<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOBrzsVOGJLpUCbb8yhL8Yw6DPOiapaj3BeicEaoKxl7Rc9g8UgSMUfjqaw/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><strong style="color: blue;"><span style="color: black;">2 <span style="color: black;">插进</span>数据透视表</span></strong></p>
<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>什么难度啦，<strong style="color: blue;">就和平时<span style="color: black;">插进</span>数据透视表<span style="color: black;">同样</span></strong>：<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="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBiax2UPtjuDtJWpOlG4rYLXmDcb09EDbOlw525EeMAKbxykC0QlWaMMw/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">插进</span>数据透视图</span></strong></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;">用鼠标点击数据透视表区域</span></strong><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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOByoDx4wFVJ2DvicSQBRFKIHVibpmotbQS8YS7NRG5s9ltQiaPwGHYfjIvw/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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;">其实<span style="color: black;">能够</span>跳过<span style="color: black;">过程</span> 2，直接<span style="color: black;">插进</span>数据透视图</span></strong><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> 2 可有可无了。</span></p>
<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBRDSDiaHbVAZza7qcv30wNU6mgrgxmMfed6oK6JPXwDsFqicg4AIJf7Rw/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></p>
<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;"><strong style="color: blue;"><span style="color: black;">4 设置数据透视图</span></strong></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;">要点一 数据透视图的数据源是与数据透视表绑定在<span style="color: black;">一块</span>的</span></strong><span style="color: black;">，<strong style="color: blue;">你不<span style="color: black;">能够</span>修改数据系列的引用区域</strong>。</span></p>
<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>数据，打开 <strong style="color: blue;"><span style="color: black;">选取</span>数据源 </strong>对话框后，你<span style="color: black;">能够</span>看到图例项和水平轴标签的<strong style="color: blue;">添加, 编辑, 删除等按钮都是灰色的状态</strong>，这<span style="color: black;">寓意</span>着<strong style="color: blue;">你不<span style="color: black;">能够</span>像普通图表那样修改数据系列的数据区域</strong>。这是数据透视图与普通图表的区别之一。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOBv6UbM8UalB06KBOw3XPkFnmTCPgjria7B8Jx8Lz1DYBgsr5tiaJov8YQ/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><span style="color: black;">要点二 字段按钮</span></strong><span style="color: black;">。细心的你<span style="color: black;">亦</span>许<span style="color: black;">已然</span>看到，<strong style="color: blue;">数据透视图相比于普通的图表，左上角和左下角多了几个灰色的按钮。</strong>这几个按钮叫做字段按钮，左上角的计【数项：日期】叫做值字段按钮，它<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="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOBvBytIWAArJcR8ibmpY2n0ROPfnrxNowpibiacpbDwocT7eUdxRt9HYh1A/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">暗示</span>坐标轴的含义。<span style="color: black;">这儿</span><span style="color: black;">表率</span>坐标轴是日期列<span style="color: black;">按照</span>年和月组合得到的，刚好与数据透视表的汇总对应。【年】【日期】两个是坐标轴字段按钮都有倒三角符号，<strong style="color: blue;">点击它们<span style="color: black;">能够</span>直接在图表上对年和日期这两个字段进行筛选操作，图表<span style="color: black;">能够</span>动态变化</strong>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBx3DOKOPmBJx4a46Jtd5s2ibB6v93AN4LmPVVUvwFHXYRVLdxKd09cvQ/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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;"><span style="color: black;">图表上的值字段按钮是数据透视图与普通图表的另一个区别</span></strong><span style="color: black;">。<span style="color: black;">倘若</span>你觉得这几个灰色的按钮和图表不协调，<strong style="color: blue;">你<span style="color: black;">亦</span><span style="color: black;">能够</span><span style="color: black;">隐匿</span>它们</strong>。<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="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBYmWkKKT7TaklK2aTJMJ9lerEcebG9Ch6B3msuZiaAuZUDcgIaYicC4aQ/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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;"><span style="color: black;">除了<span style="color: black;">以上</span>的两个<span style="color: black;">区别</span>点之外，数</span></strong><span style="color: black;"><strong style="color: blue;">据透视图与普通图表的操作是<span style="color: black;">同样</span>的。你<span style="color: black;">能够</span>像设置普通图表<span style="color: black;">同样</span>设置数据透视表的各项参数：坐标轴，数据标签，标题等等</strong>。<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="https://mmbiz.qpic.cn/mmbiz_gif/SfYvgfibDngchPsApqKUQPKH3rfL64wOBdpGKF2OT4AaYJ8kFKrczSxQIibGRomu2fk1e8bwcBG2zxZQLiaSAsIhQ/0.gif?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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;">前面谈到，数据透视图是以数据透视表<span style="color: black;">做为</span>数据源的。<strong style="color: blue;">当数据源改变时，数据透视表的数据需要点击刷新才会将最新的数据加入计算。</strong>数据透视图<span style="color: black;">亦</span>不例外，<strong style="color: blue;">当数据源变化时，<span style="color: black;">亦</span>应该点击刷新之后才会将最新的数据反映到图表上。</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOBNLbZPxYfPO4PNHgTbT72WozKPhDNEHlVJAey4lhpXnicnogxcsmRUEQ/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/SfYvgfibDngchPsApqKUQPKH3rfL64wOB94mPlk39ZOTr9bT2jKiaZoXR80Lcv8gRkKHxI285SyNCj6X0c4qTDEQ/640.png?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>
你的言辞如同繁星闪烁，点亮了我心中的夜空。 交流如星光璀璨，点亮思想夜空。 楼主发的这篇帖子，我觉得非常有道理。 i免费外链发布平台 http://www.fok120.com/
页:
[1]