qzmjef 发表于 2024-8-31 22:48:17

答疑分享121：Exce中给营销数据图表添加一条均线

<img src="https://mmbiz.qpic.cn/mmbiz_jpg/8OlVtjTxwlktbpqZO4gpXOg7xL10qbP8JwDE9CpsKiaK4jDe28Xia3rzjkpJLeBZYQ24YBahw2Zh0U7fntO8oOjQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;">
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">Office成长课堂</strong></span></p>让Office·更<strong style="color: blue;"><span style="color: black;">有趣</span></strong><span style="color: black;">·</span>更<strong style="color: blue;"><span style="color: black;">好玩</span></strong><span style="color: black;">·</span>更<strong style="color: blue;"><span style="color: black;"><span style="color: black;">有效</span></span></strong><span style="color: black;">和</span><strong style="color: blue;"><span style="color: black;">优秀</span></strong><span style="color: black;">的</span><span style="color: black;">人在<span style="color: black;">一块</span>，让自己更</span><strong style="color: blue;"><span style="color: black;">优秀</span></strong><strong style="color: blue;"><span style="color: black;">案例</span></strong>
    <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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8vURx714pWJOf7GkqicXTpvYdahLEwn4fWibkLW6pDvZUTdZt3wGMiaDqKA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">这个图表，是上期分享的<span style="color: black;">营销</span>部数据报告中<span style="color: black;">运用</span>的第二的图表，给图表添加辅助线条，区别数据的区间。</span></p><strong style="color: blue;"><span style="color: black;">图表素材下载链接</span></strong>
    <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></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;">https://pan.baidu.com/s/10DQyQAH41In9eftRrntVPg</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">提取码：</span></strong><strong style="color: blue;"><span style="color: black;">23fr</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">复制链接至电脑浏览器<span style="color: black;">位置</span>栏打开。</span></strong></p><strong style="color: blue;"><span style="color: black;"><span style="color: black;">过程</span>01</span></strong>
    <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>高版本的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;"><span style="color: black;">高版本的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;"><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;">=AVERAGE($C$3:$C$12)</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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8vNRVcRPa6rggPuPQBAeFI39LD5DIQR8fhoBF4TwUPricw5xvZ3KN8UaQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><strong style="color: blue;"><span style="color: black;"><span style="color: black;">过程</span>02</span></strong>
    <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 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/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8vw6u3SJmYrLnW2ZzWicluH2MBvcribTKt05WjRDmau97sIbxjWqHN6kBg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8vXZW9odUr1AdguS1iaARSTHkHLlrU6ya9WtJAR6TOb2C2krqYwhmsUMw/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><strong style="color: blue;"><span style="color: black;"><span style="color: black;">过程</span>03</span></strong>
    <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;">选中均线，设置数据系列格式，线条实线，宽度1.25磅，类型短划线。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8v2ib3yc1pNic9GGQLs54KNib0L2eShPYD2CCogaWGbYHSyUNb3pHCIsSqQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><strong style="color: blue;"><span style="color: black;"><span style="color: black;">过程</span>04</span></strong>
    <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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8v8f0xmibOEhibqicJkOX8pMuCTV5Ag7gLew8icGpiaTje27ZQ6cJOPylnvcQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p><strong style="color: blue;"><span style="color: black;"><span style="color: black;">过程</span>05</span></strong>
    <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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/8OlVtjTxwlmFmLjrZ1PdPeM2mZ6yCq8vyo9HiakTHlBLod2COvdPj6C7w9l3AXC3aGBuw8hLMgN3fz4sdd37Fqg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>未完待续<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">后期更新图表<span style="color: black;">文案</span>，尽情期待！</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/8OlVtjTxwlnblCda3SXy8ACnDlm8xJiaopzNeL47VnunAaY0cQSYicllDToPt6SoOic5vCJI5OXBhialUibzHk0NlKQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/8OlVtjTxwllTkFcQ1ovhwqs2TNF5dXSqOhficIqg7EmU4ibeGAbjj8iaEILWOboYAXxg1AlLnCcFuGtQeCqmRClqg/640?wx_fmt=gif&amp;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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/8OlVtjTxwlmia48qvibshEQdhTdW9gP4La8OGr4RYOUSGYypYHO9INqrgKyUsTl0du3wXzECymevkSwI0aBxgIQQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/8OlVtjTxwlmia48qvibshEQdhTdW9gP4LaZJ1MUEg0lNNXe7K4026W3HLWPuM3WPmibebcuictythpw9nveqQibutuw/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/8OlVtjTxwlnCDEVCVUlpUvYdZlJTjfCqCiagO3ggKy5yoB7NVaOicKV69USoTelibhibLWuIA9CJR4eO8zlnnlJoLw/640?wx_fmt=gif&amp;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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/8OlVtjTxwlnLhuPefLBsJogDLrea7iaiawoU4NOibBLkKtEfpGNQGSY81xfKPrMvn6XFIRicVLuIb81G1JUs5JyFTg/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/8OlVtjTxwlm9emclqcVs1MRCSL4vkO56wYwghau4Mhuq7aZFFPkNTyLaTravTKn3DP79tTT6AW4ZCUg2s9gyHg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">↙点击“阅读原文”查看<span style="color: black;">更加多</span>精彩内容</p>




wrjc1hod 发表于 2024-9-29 01:17:07

论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。

qzmjef 发表于 2024-10-5 19:27:09

谷歌外贸网站优化技术。
页: [1]
查看完整版本: 答疑分享121：Exce中给营销数据图表添加一条均线