显著标识Excel图表中的节假日数据
<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>。如下图中带标识的数据点，完工量都比较少。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/bc00ff87975f4493bf95b8f369c5468d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=Y7ouBSKZOg%2FBoyBgF%2FZXOEda9oE%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;">1、<span style="color: black;">增多</span>辅助数据区域</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下图中A1:B32为原数据区域。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">避免图表横坐标轴倾斜<span style="color: black;">表示</span>，新建“日期”辅助列，当月1号和31号按段日期格式<span style="color: black;">表示</span>，其他按数值<span style="color: black;">表示</span>。如下图D列。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在F2单元格输入公式：=IF(WEEKDAY(A2,2)>6,1,0)，并将公式复制到F2:F32数据区域。遇到周日返回1，工作日和周六<span style="color: black;">表示</span>0。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在E2单元格输入公式：=B2，并将公式复制到E2:E32数据区域。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c5ee58f3e7d54f11902491ffdd0962e4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=b9q1RKJ%2FmtT%2BigO5xNl19sPATcA%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;">2、<span style="color: black;">插进</span>折线图</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">选取</span><strong style="color: blue;">数据区域D1:F32</strong>，单击菜单栏<strong style="color: blue;">[<span style="color: black;">插进</span>]</strong>=><strong style="color: blue;">[图表]</strong>=><strong style="color: blue;">[带标记的折线图]</strong>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/44b0dfc937c3401aaeac109f093925d1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=vvptQAWeZ0yqLw7utQOYlv4x9kI%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;">3、将辅助列<span style="color: black;">调节</span>为柱形图</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">右键单击</strong>图表<strong style="color: blue;">“<span style="color: black;">是不是</span>周末”</strong>系列，<span style="color: black;">选取</span><strong style="color: blue;">[更改系列图表类型]</strong>。在弹出的<strong style="color: blue;">[更改图表类型]</strong>对话框，将<strong style="color: blue;">“<span style="color: black;">是不是</span>周末”</strong>系列<span style="color: black;">调节</span>为<strong style="color: blue;">“簇状柱形图”</strong>，并勾选<strong style="color: blue;">“次坐标轴”</strong>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5829b069c2cd4b2494464e1566bb5d3a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=K3VKgPWTFVR28g8F6Vs%2Ff4RJNuc%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;">调节</span>柱形图间隙宽度</strong>。右键单击<strong style="color: blue;">“<span style="color: black;">是不是</span>周末”</strong>系列，<span style="color: black;">选取</span><strong style="color: blue;">[设置数据系列格式]</strong>，将<strong style="color: blue;">[间隙宽度]</strong>设置为<strong style="color: blue;">100%</strong>。<span style="color: black;">同期</span><span style="color: black;">调节</span><strong style="color: blue;">“填充颜色”</strong>，本例中<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-qvj2lq49k0/01d10032ca7a4db7b8602114f1ce1461~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=uD7pC0a2KWD8BeXlXV3idffYY2w%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/0faf38ffbdb14b5cbf189ffcf121870f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=kBFNqKIeTDtOFTPhHtJnSvpLWUI%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;">4、<span style="color: black;">调节</span>次坐标轴格式</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">右键单击<strong style="color: blue;">次坐标轴</strong>，<span style="color: black;">选取</span><strong style="color: blue;">[设置坐标轴格式]</strong>，将<strong style="color: blue;">[最小值]</strong>设置为<strong style="color: blue;">0</strong>，<strong style="color: blue;">[最大值]</strong>设置为<strong style="color: blue;">1</strong>。<span style="color: black;">同期</span>将<strong style="color: blue;">“文本填充”</strong>设置为<strong style="color: blue;">“无填充”</strong>。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/57d2e0834b4e4213bcef21cd0f68f622~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=v%2F6ZW1iMaaxNRW3T6gbIbfCbmss%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/64b94013d659494db3dd042ea30c43ab~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=ggtEgUwBYZwqbB75eSBSidIaSdM%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;">5、<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;">调节</span>图表标题</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">删除图例</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">调节</span>网格线</strong>。<span style="color: black;">例如</span>将<strong style="color: blue;">[短划线类型]</strong><span style="color: black;">调节</span>为<strong style="color: blue;">“长划线”。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/a45637ce5baf4315a53790f54507e562~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727979790&x-signature=ApZTiY6mP4ZYB3bzdKA%2BBZsLXlU%3D" style="width: 50%; margin-bottom: 20px;"></div>
外贸网站建设方法 http://www.fok120.com/ 楼主听话，多发外链好处多，快到碗里来！外链论坛 http://www.fok120.com/ 楼主节操掉了，还不快捡起来！ 论坛外链网http://www.fok120.com/ 你的见解真是独到，让我受益良多。
页:
[1]