Excel营销数据怎么做好看，这般的图表展示更直观
<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>工作中必须要学会的一项技能。今天<span style="color: black;">咱们</span>来学习一下，<span style="color: black;">怎样</span>让你的Excel图表能够变得与众<span style="color: black;">区别</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>来看一下下面的表格数据，<span style="color: black;">倘若</span><span style="color: black;">咱们</span>就<span style="color: black;">这般</span>把数据交给老板，那肯定是会被批死。像下面的数据全都是对在<span style="color: black;">一块</span>，一点都不直观<span style="color: black;">因此</span>做数据不<span style="color: black;">意见</span><span style="color: black;">这般</span>操作。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/7db9df5a0a9743e09bae813421d0dea3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725685275&x-signature=Ujy20XUZUoCqXBKMYT7bi0D%2FmQo%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><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>来看一下效果图。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/218121b77008485abc6d2f5ade0e6cd8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725685275&x-signature=1ACEmdKj%2F12t0kW7Ij248vQdFX8%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><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>的操作过程。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/ee550c59428945969b20cac80a3c5c97~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725685275&x-signature=zUMEhee2207LoJCygdQR2JJrJwo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">第1</span>步：</strong><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/pgc-image/c76c6d75f009409c96429133a153aa76~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725685275&x-signature=pJWVIKXHKsx%2BaPGeQFScUCq7M98%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">第二步：</strong><span style="color: black;">选取</span>数据，点击插入—图表—<span style="color: black;">选取</span>柱状图，将图表辅助线删掉，<span style="color: black;">调节</span>一下图表的颜色。长的改为灰色，短的改为红色，<span style="color: black;">这般</span>看起来就会有对比；</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">第三步：</strong>点击一个图表框，<span style="color: black;">选取</span>右键设置格式，将图表重叠值改为100%，<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://p26-sign.toutiaoimg.com/pgc-image/b9d3b1acde8e4cfbacda6813ba5b7e71~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1725685275&x-signature=dzgL2uUDxBbD2Jp9fo7GNe0ZrIQ%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><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>
你的见解独到，让我受益匪浅，期待更多交流。
页:
[1]