论坛 › 北京 › Excel制作动态甘特图大揭秘！

l14107cb 发表于 2024-10-2 16:08:38

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;">excel教程</span>，回复<span style="color: black;">1</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/k6kCsib3eJMzvXoW4tQRplnypYmzt5nOHHqufViceoYibiaIb5EJ3vXeARJUat7T9kUrT7A8kpYtFCK77dV6ibmlHFw/640?tp=webp&amp;wxfrom=5&amp;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 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>。甘特图用途广泛，在建筑、汽车、IT、化工、机械等<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>，如Visio、Project等专业软件。其实用Excel<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/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEibLDZuIlbuQibaQT4o0UrdxiaROgXJwhn06EcqTOwqZOfSfJLO5PANyog/640?tp=webp&amp;wxfrom=5&amp;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;">下面用2010版本讲解<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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">1、</span>数据源的准备</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEBgvCamIHz8trV7uzEpMpwIc0Tlvdxp5HKXelZT0fevucaH5ibH6rGgw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><strong style="color: blue;"><span style="color: black;">1.</span></strong><strong style="color: blue;"><span style="color: black;"><span style="color: black;">起始</span>日期</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">公式很简单，在B4单元格输入=B3+C3，下拉<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEEL0TdsGRgkh0o8cK3CWaF3rcBfUqAOiaxnvU47K6odWcBSSpjcKVVZw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2.</span></strong><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>是SUM函数的一个经典用法，累计求和的公式运用，在D3单元格输入公式</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=SUM($C$3:C3)，下拉。</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;">第1</span>个C3）<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAElyf9N64YYn1gIZnwJjhOA49JZZTouGxheUeVxIgTketu91oTyszBEQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3.</span></strong><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>很简单，在E3单元格输入=B3+C3下拉<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAE2ciciamj9cZrdlmPyKs6TPibEW2AU4ibuzIV7nicApFSiaGBbyQXIozvlCYA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAExccc1au2nKFPbNwu5J5uYAW8AUqzS5uN8yUVECAgGoWwIW43yXh9Jw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">A12单元格是一个手动输入的数字，<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;"><strong style="color: blue;"><span style="color: black;">4.</span></strong><strong style="color: blue;"><span style="color: black;">各<span style="color: black;">周期</span>已完成天数</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">H2单元格输入公式</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">=IF(D3&lt;=$A$12,C3,IF(D3-$A$12&lt;C3,$A$12-N(D2),0))，<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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">首要</span></span></strong><span style="color: black;">，计算各<span style="color: black;">周期</span>已完成天数，是固定与进行天数A12进行比较计算，<span style="color: black;">因此</span>公式中A12采用了绝对引用$A$12。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">其次</span></strong><span style="color: black;">，公式<span style="color: black;">重点</span>用到了IF函数，<span style="color: black;">经过</span>比较某<span style="color: black;">周期</span>的累计天数（如市场调研<span style="color: black;">周期</span>累计天数D5）与A12单元格的<span style="color: black;">体积</span>来确定该<span style="color: black;">周期</span>的完成天数。<span style="color: black;">倘若</span>D5&lt;=A12，则返回第二参数C5<span style="color: black;">亦</span><span style="color: black;">便是</span>所需天数；<span style="color: black;">倘若</span>D5&gt;A12，则继续判断D5与A12的差<span style="color: black;">是不是</span><span style="color: black;">少于</span>需要天数C5，若<span style="color: black;">少于</span>，返回第二参数A12- N(D4)，若大于则返回0。在表格中<span style="color: black;">能够</span>看到，<span style="color: black;">倘若</span>进行天数为10，D5&gt;10,并且D5-10=1，<span style="color: black;">少于</span>C5，<span style="color: black;">因此</span>完成天数等于A12-N(D4)=10-D4=10-8=2，<span style="color: black;">亦</span><span style="color: black;">便是</span>市场调研项目只进行了2天。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAE5tib0qhb9AC2lZicOuLGZIx61BE0vfia4ia7JNjyg6C50bF0zHrWfq7RPQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5.</span></strong><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;">这个公式就非常简单了，I3单元格输入=C3-H3，下拉<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAETKXdjmjX3ROSXFYNOshW08SkibDOnBibXiaKpiaJ8kNPzoP37r1G4fMzrQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>以Excel2010版进行截图演示。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">2、</span>基本图表的制作</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>A2:B9区域，按住Ctrl键再<span style="color: black;">选取</span>H2:I9区域，<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEARztdHlhwhv4D0Fibu9vGtMzZUtCJZXtGhGyJYR3LQ6AKvDGN9tGMtw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEEeOYb5Xuq4RfnlDFSRudpfCkxWmj7ghObkzOokXW4A26Q1zFIu29tA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEalWgJNPzUqjtdE8alLwyK0V6TLR9wzEqS5pxNkqsFiaMYKlysWWqMKw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAE0CACFeiapbyg1Re5PSuBvS00Dn2RQC5RITfK2iamNhV6ribcuaicPjnPVw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>B2单元格，系列值处将原有的内容删除后<span style="color: black;">选取</span>B3:B9单元格区域，点击“确定”：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEF9FDRdIeC6Vibs647QggOKCENEDYw7cic9k0ec2FNf1lloiaHWZj38NTw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>日期”单击“上移”按钮<img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEksbhfMe5P4N2WfEqEpQkeUM9Oc4a40OsnMI0XiawcNX8IM69VHlxRNw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;">将<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEfl4kJoufibxbkYzX9QTibV293XUms4ia3XlFBHY084H88huicqWdDn2QIg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEyM90AZBlia4BbXgHuibn2ZbibKiaDsbRB71qc1GRZPgb2pg2olHc90w6VA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>A3:A9单元格区域，<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEyEJTMRtdiaS2EazKpQGK0aB6uuH61gLdGkHrImUj1xfRypShIJtqThg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEicH49tkC7NDkNXyba62bda06xMQezfehzRN4ljE8IvSiaX6kOnT7hIMA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAE2wOzbj6YIfOt8SlJt6z9icCajwtheLKiaPXghaHUkWkPFjQibwyvRzDOA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEU9ZrLcuNRmHkBsEE3Gm4qZhbsliarlGCA8W3FPye57lXkgh775cnOiaQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEspXoQJv3vxq6D4vvNh06FU3PEP4D4eZCo3ibLASZRGS5TiaPjwWticZdA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">第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></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEXRtpzZObPZRbqlsVfeP3bhfFwjYYDXBQHlHIdckpibiaKbfiawZxJWA5Q/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEyqBJorG1hFNSwkEl7Hv0DnyiciaD8HcSKAgVr6MpKnY0C3RU6nD3cPjQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEBYlkODicGywet4xcbSfhaUAd4rEl9z7k9XVQnnHmibrAHKp4Jvazndhg/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEKibuD9DHq0yzzcy08Xadia5YcDGicDzDMpHE3MQ7SPicmbK3FfpIRt3tNQ/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEPIZquTAzbgRX3k5DV9dS14msKDF90NGDXFobGeqpPtib31gTBxuLOtA/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEf5JS7OD0vaYzD7arqyvmKg04VIiaw0YiaSrdzKtP4huNV2KNdRve7fIw/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEHma7guo68IR7HBdJrhCW1ssx59GkwSAdeSF5hauZpw7HCIaF0iaf6Ow/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwWTzphntuTqrLDhINmTpAEvjFZOhaySwib5icRCx6rPuMaWl7lKIxXHKwsUMtXrm90BfTOXZuTqk3w/640?tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>“设置坐标轴格式”：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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></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;"><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></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;"><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></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;"><span style="color: black;"><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></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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">3、</span>动态图表的完成</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>动态图表，<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>工具”选项卡的，忽略这一步。）以2010版为例，<span style="color: black;">选取</span>“文件”→“选项”命令，在“Excel选项”中自定义功能区，勾选右侧的“<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;"><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></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工具栏中就会看到“<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;"><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></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;"><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></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;"><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></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;"><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></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>”选项卡中，分别设置以下内容：最小值1，最大值41，单元格链接<span style="color: black;">选取</span>A12，点击“确定”。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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></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;"><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></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>公式=TODAY()-B3来计算进行天数（A12）。<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;"><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></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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1.</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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2.</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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">3.</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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">4.</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 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;"><span style="color: black;"><strong style="color: blue;">温馨提醒：<span style="color: black;">倘若</span>您想要本文配套的练习课件，请加入QQ群：316492581下载。</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><span style="color: black;">举荐</span>两套部落窝教育滴答老师录制的Excel视频教程：</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;">第1</span></span></strong><span style="color: black;">，17集函数公式视频教程，扫下面二维码观看学习：</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;"><span style="color: black;">温馨提醒：购买《<span style="color: black;">1星期</span>Excel直通车》全套Excel视频教程，赠送17集函数视频教程，伙伴们加老师<span style="color: black;">微X</span>：603830039领取哈。</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;">1星期</span>Excel直通车》全套视频教程，<span style="color: black;">包括</span>Excel技巧、函数公式、数据透视表、图表，四大完整模块知识点和职场案例。扫下面二维码购买观看：</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;">转载请联系！</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;"><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>

nqkk58 发表于 2024-10-13 14:20:07

感谢楼主分享，祝愿外链论坛越办越好！

4zhvml8 发表于 2024-10-18 16:42:07

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

4zhvml8 发表于 2024-10-23 13:44:58

认真阅读了楼主的帖子，非常有益。

m5k1umn 发表于 3 天前

外贸网站建设方法 http://www.fok120.com/

查看完整版本: Excel制作动态甘特图大揭秘！