nykek5i 发表于 2024-9-1 01:10:27

是谁还不会数据分析报表的制作？只需要7步超简单的！


    <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;"><span style="color: black;">报表数据分析</span></strong><span style="color: black;">，相信搞IT的人都不陌生。但其实做报表不只是IT工程师的工作，<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>工具操作，就能制作出满足<span style="color: black;">区别</span>业务场景的数据报表。</span><strong style="color: blue;"><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></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>、人事等<span style="color: black;">平常</span>的业务场景，点击链接<span style="color: black;">就可</span>下载：<a style="color: black;">「链接」</a></span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>数据分析报表的<span style="color: black;">归类</span></h1>
    <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>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">1. 财务数据分析报表</h1>
    <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></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;">资产负债表、利润表、现金流量表。</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></strong><span style="color: black;">数据准确无误，能够反映企业的财务健康<span style="color: black;">情况</span>，<span style="color: black;">帮忙</span>决策者<span style="color: black;">评定</span>企业的盈利能力和偿债能力。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">2. <span style="color: black;">营销</span>数据分析报表</h1>
    <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 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></strong><span style="color: black;"><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;"><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><span style="color: black;">营销</span>策略，<span style="color: black;">提高</span><span style="color: black;">营销</span>业绩。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">3. 采购数据分析报表</h1>
    <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></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;">采购成本分析、供应商<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></strong><span style="color: black;"><span style="color: black;">经过</span>对采购数据的分析，企业<span style="color: black;">能够</span>优化采购流程，降低采购成本，<span style="color: black;">加强</span>采购效率。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">4. 仓库数据分析报表</h1>
    <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></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;">库存量变化趋势图、库存周转率分析、缺货率统计等。</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></strong><span style="color: black;"><span style="color: black;">经过</span>仓库数据分析，企业<span style="color: black;">能够</span>更好地管理库存，减少库存积压，<span style="color: black;">加强</span>库存周转率。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>数据分析报表的制作原则</h1>
    <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></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <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>数据分析报表的受众。</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></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></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></p>
                <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这个问题就指向了一款优秀报表的要素。</span></p>
            </div>
      </div>
    </div>
    <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></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">1. <span style="color: black;">知道</span>受众</h1>
    <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 style="color: black;">咱们</span>的受众分为三类：高层领导、中层管理者、一线人员。</span></p><span style="color: black;">高层领导：<span style="color: black;">她们</span><span style="color: black;">一般</span><span style="color: black;">期盼</span>快速概览业务全貌，关注战略层面的趋势、关键绩效指标（KPIs）的达成<span style="color: black;">状况</span>、以及可能影响业务方向的重大变化。</span><strong style="color: blue;"><span style="color: black;"><span style="color: black;">因此呢</span>，报表应聚焦于高度概括的数据摘要、趋势分析以及关键<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>达成的<span style="color: black;">原因</span>。</span><strong style="color: blue;"><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></strong><span style="color: black;">一线人员：<span style="color: black;">她们</span>直接参与业务执行，对<span style="color: black;">平常</span>操作中的<span style="color: black;">详细</span>问题有深刻体会</span><strong style="color: blue;"><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></strong>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">2. 清晰目的</h1>
    <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><span style="color: black;">定义问题：</span><strong style="color: blue;"><span style="color: black;">报表的宗旨所在有两个方向——<span style="color: black;">处理</span><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><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><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>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">3. 数据准确</h1>
    <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></p><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><span style="color: black;">数据清洗：对数据进行预处理，<span style="color: black;">包含</span>去重、缺失值处理、<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>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">4. <span style="color: black;">明显</span>重点</h1>
    <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><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><span style="color: black;">可视化优化：利用图表、图形等可视化手段，直观展示数据趋势、对比和<span style="color: black;">反常</span>点。</span>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">5. 易于理解</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">报表设计应兼顾专业性和可读性：</span></p><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><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><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><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><span style="color: black;">咱们</span>的收获和<span style="color: black;">详细</span>的下一步的行动指南。</span>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">3、</span><span style="color: black;">怎样</span>制作数据分析报表？</h1>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/7d6114b785df4b83a01f170313a48955~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=nNDv5BIjlGOwHiv0xvUKdmbn13M%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;"><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-6w9my0ksvp/77a94453048a465a8a8492c77753c12e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=rcC8%2FcEwsFI8D2ewZ%2FqkFKfG2zk%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;">上图是利用报表制作工具FineReport制作的一款简单报表<span style="color: black;">最后</span>效果图，FineReport是一款功能强大的数据报表工具，支持多种数据源接入，含有丰富的图表类型以及灵活的报表设计。<span style="color: black;">咱们</span>今天就教<span style="color: black;">大众</span><span style="color: black;">循序渐进</span>利用FineReport这一工具，制作出上面的效果。FineReport的免费<span style="color: black;">位置</span>放在下面了，<span style="color: black;">大众</span><span style="color: black;">能够</span>跟着<span style="color: black;">一块</span>实操：</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">新建数据连接</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">新建数据连接的目的是让 FineReport 设计器连接数据库，<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;">打开设计器，点击最上方菜单栏中「服务器&gt;定义数据连接」，弹出「定义数据连接」对话框，设计器<span style="color: black;">已然</span>默认连接了一个名为 FRDemo 的内置数据库，点击「测试链接」，弹出「连接成功」提示框，<span style="color: black;">暗示</span>数据库 FRDemo 成功与设计器<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-6w9my0ksvp/e9e36d159db642b39aef0e8b8d28e60c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=hkvq87JGjij3tzgFlKikCR%2FpcNI%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;">接下来就<span style="color: black;">能够</span>从这个数据库中取数用于报表的设计。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">新建报表</h1>
    <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></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/70f65dbd94fe40b7952cf8c42dde2d72~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=aqi%2BUKFqWwljdNklZZSwJaSCE5o%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;">可快速新建一张空白的「普通报表」。如下图所示：</span></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/01ec9f75536942068fa70ff326ecff16~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=9n989WY3gSaQxqiWNeGjE81DqWU%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;">普通报表默认主题为「经典浅灰」，主题名<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-6w9my0ksvp/3d23a911dd8e418fb07c266973742f21~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=53DNnkAZqLbdodevmeZ0fW53tng%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">准备数据</h1>
    <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>「模板数据集」，点击上方的</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5e279c1019de4e67876f06e30d99c6bd~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=Im17uw0mCUgQfv7B2HuVfYDRiEk%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;">新建数据库<span style="color: black;">查找</span>ds1，输入 SQL <span style="color: black;">查找</span>语句：</span><span style="color: black;"><span style="color: black;">SELECT * FROM 销量 </span></span>，取出「销量」表中的所有数据。</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a523180ae69a4107a74950fd2ee98e6e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=hUFpuRZOD3xoKhM7H1q4ntDTivY%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;">新建好数据集之后，可在数据集管理面板查看取出的数据。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2d7825ebb16e48fe8a83428d50166bf4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=xsDttM13PHqycrlIbSCQeq%2BOG4E%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;">至此报表的数据准备工作<span style="color: black;">已然</span>完成，下面对报表的样式进行设计。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">表格设计</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）大标题</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中 A1~D2 单元格，点击「合并单元格」按钮，将其合并。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8022a3d15a1c4444a288085b00919e7d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=yW4mNPL5SzrXa0nhhTxBzfEyH3Q%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;">写入报表标题「地区<span style="color: black;">营销</span>概况」，点击右侧属性面板「单元格属性&gt;样式」，<span style="color: black;">选取</span>「跟随主题&gt;大标题」。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e8b348cc1f7a48f0958ad2d98dced8ee~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=lQIohEB8oHSUPEnGKg0vhcI%2Balk%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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">从 1.3 节效果图<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;">将 A3 、B3 单元格合并后选中，点击上方工具栏「<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-6w9my0ksvp/c42e091e39de4d8d83be1a5098213269~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=3WXTJQptQ4C9lkPRaDYvibNhcSY%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;">适当<span style="color: black;">调节</span>一下 A3 单元格的宽高，再设置 A3 单元格样式为「跟随主题&gt;小标题」。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/544a936915b845b89a34cca0a12b675e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=7EKNNFIaHKDkikoycrqnV1ZO6D0%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;">当设置为主题的「小标题」样式时，<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;"><span style="color: black;">修改之后可看到单元格样式<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-6w9my0ksvp/5115719c4acb48d6abf4c11045bbad0b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=fmwJ3WRrVeyRuCuutn%2B1HtwT3pw%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;">3）填充表格数据</span></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/bae5840d808b4def81d4283cabb6bb85~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=z%2FiWOprG1onMwix1I56xaCiPB9s%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;">数据列拖入单元格时，单元格扩展默认纵向扩展，<span style="color: black;">咱们</span>需要将「<span style="color: black;">制品</span>」所在 C3 单元格设置为「横向扩展」。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中 C3 单元格，点击「单元格属性&gt;扩展」，修改扩展方向。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8ff37379f8814a23936fa971a6cc79e5~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=3DgrIMz8jpugM5XFMxISi0xtTwA%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></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></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>输入表头，在 D3 单元格输入文本「<span style="color: black;">营销</span>总量」，将 A5、B5 单元格合并后输入文本「总计：」。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选中 C5 单元格，<span style="color: black;">插进</span>求和公式，C4 为「销量」，即纵向统计<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-6w9my0ksvp/58ababa5c1af46718a4c2585431d164d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=sZ6i0dVflfLJVq9qeAn6nFWdQ38%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;">D4 单元格要横向统计<span style="color: black;">每一个</span><span style="color: black;">营销</span>员的<span style="color: black;">营销</span>总量，同理<span style="color: black;">插进</span>求和公式</span><span style="color: black;"><span style="color: black;">sum(C4)</span></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;"><span style="color: black;"><span style="color: black;">因此</span>本例 D4 单元格需要<span style="color: black;">按照</span>「<span style="color: black;">营销</span>员」字段进行计算，即 D4 单元格的左父格需设置为「<span style="color: black;">营销</span>员」所在的 B4 单元格。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b8a7c3f2e170472eae67b9cc39b6786f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=Jlda7SS%2FSORpdRMtPcAF7vO3bl4%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;">最后在 D5 单元格<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;">5）设置剩余单元格样式</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">C3、D3、A4、B4、A5 单元格样式均设置为「跟随主题&gt;表头」，C4、D4、C5、D5 单元格样式均设置为「跟随主题&gt;正文」。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/644b3c6def8146ccb136e6820c708966~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=oVUzVvmx6JNw7azEx40v5%2FBIL7g%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;">6）到<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-6w9my0ksvp/2186729e2ce0490397ca189eb76cedd9~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=ijjKDid7L4ePH4FB5kc7rfNexnU%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">参数设计</h1>
    <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></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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1）新增模板参数</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>「模板&gt;模板参数」，弹出模板参数设置对话框，新增一个参数，双击参数名重命名为「地区」，并设置默认值为「华东」。如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d9dcefcbf32d47b4b1255a8dc7d1271c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=zTG6LerYaSnopdKNE6gPtvKyC3A%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></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 style="color: black;">编辑</span></span>按钮，进入参数面板设置界面。可看到右上角控件设置面板处会<span style="color: black;">表示</span>未生成的参数，点击<span style="color: black;"><span style="color: black;">地区</span></span><span style="color: black;">或</span>点击<span style="color: black;"><span style="color: black;"><span style="color: black;">所有</span>添加</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></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/89bb6d48afe548039f5292f2d441040e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=dBC182varzTkfnbHtxdRGj8E95Y%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;">3）设置控件</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></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/64c770fd0f5f4fa0890f512b12e77cb1~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=3vt%2BFaXSuSwA%2FxMYStI9aEcoXpU%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></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></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>「属性」，点击数据字典「编辑」按钮，类型设置为「数据库表」，数据库为「FRDemo」，<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-6w9my0ksvp/a128abfbc8a444cd95f3bbb47fa6f5f9~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=BXsnroXwSr13kygAXAZEQ46wX3k%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）选中参数面板「para」，可设置参数面板的属性和样式。本例将「点击<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-6w9my0ksvp/d03d092d71114c0096259a2c96efac29~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=9kzPxn55eCS5%2F%2F3o0GgfG7eXh9A%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;">6）设置单元格过滤</span></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/4b958a992bfc41abbc309ffea6738ce2~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=QKpLykTv0v5lxE52iOR5g4Xn0r8%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;"><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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">双击 A4 单元格，在弹出的数据列对话框中<span style="color: black;">选取</span>「过滤」，添加一个普通<span style="color: black;">要求</span>，让</span><span style="color: black;"><span style="color: black;">地区</span></span>等于参数 <span style="color: black;"><span style="color: black;">$地区</span></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/506d04d921e749b18e67e15c438044d8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=CKB6%2FLNZ1wBIMLMu90jy9WKqr5s%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;">7）到<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-6w9my0ksvp/5e740907a7974482ab54795a2e951b1a~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=iB196nOfzB84BuKNyDZYi%2BQ%2FX5Q%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">图表设计</h1>
    <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;"><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;"><span style="color: black;">1）<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;">将 A7~D18 单元格合并后选中，点击上方工具栏「<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-6w9my0ksvp/1f52b244170044a3b02aa19418bf07c6~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=EGP6w0MY8hRPFyYdDdhk0Lhj5%2BY%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></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;">选中图表后，点击右侧属性面板「单元格元素&gt;数据」，<span style="color: black;">选取</span>数据<span style="color: black;">源自</span>为「单元格数据」，<span style="color: black;">归类</span>名为公式 </span><span style="color: black;"><span style="color: black;">=B4</span></span>，系列名为公式 <span style="color: black;"><span style="color: black;">=C3</span></span>，值为公式 <span style="color: black;"><span style="color: black;">=C4</span></span>。即图表 X轴 为 B4 单元格的「<span style="color: black;">营销</span>员」，系列为 C3 单元格的「<span style="color: black;">制品</span>」，Y轴 的值为 C4 单元格的「销量」。如下图所示：</p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/edd80a4d9a6e40bca8c969552f467af2~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=PUTOizA8G5t5O4iO75v3JAbpPiM%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;">3）图表样式设置</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>在图表「样式&gt;标题」中取消勾选「标题可见」<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-6w9my0ksvp/c2ed6e29a9bc439f93d341b55d3e5dcf~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=WEZSa7R7YxYsZ3t1Svx7Axjq0v8%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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6806c6a2e4bb49c284376a42140e07cc~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=kt9EXpD9ZmHA2GtsVk9GjNembS4%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;">至此这张报表<span style="color: black;">已然</span>制作完成，下面<span style="color: black;">咱们</span>就<span style="color: black;">能够</span>查看一下报表的效果。</span></p>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">效果预览</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">(1) PC 端</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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a35e9e17e9c14c82bcc42358eb05bb8e~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=%2BBzjquP3bSc%2BUvOVYLM%2BkLrk%2FRk%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <h1 style="color: black; text-align: left; margin-bottom: 10px;">(2 ) 移动端</h1>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">App 端和 HTML5 端均支持，效果如下图所示：</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c6f60ae553964d03ac9ba33801926bd9~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1725686312&amp;x-signature=yZ6MFOXYo0emRmsOjiNhizk7Y90%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;">数据分析已<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;">最后分享一份《数字化全流程资料包》，点击链接领取：<a style="color: black;">「链接」</a></span></p>




啊呀呀 发表于 2024-9-4 10:45:58

一看到楼主的气势，我就觉得楼主同在社区里灌水。

nykek5i 发表于 2024-9-5 17:54:30

我完全同意你的观点，说得太对了。

4zhvml8 发表于 2024-9-26 19:32:38

软文发布论坛开幕式圆满成功。 http://www.fok120.com
页: [1]
查看完整版本: 是谁还不会数据分析报表的制作？只需要7步超简单的！