Excel 巧用形状填充，制作鱼缸图
<h2 style="color: black; text-align: left; margin-bottom: 10px;">前言</h2>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">本文<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>知识点：系列重叠、间隙宽度、图表区域。</p>
<h2 style="color: black; text-align: left; margin-bottom: 10px;">目录</h2>图表介绍图表<span style="color: black;">特殊</span>绘图<span style="color: black;">过程</span>
<h2 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>图表介绍</h2>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">数据源：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-0225a9c46f15827891330d3a34602549_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">绘制的效果图：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-b03e2863bb5b68ec7423f621c42ab6e4_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<h2 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>图表<span style="color: black;">特殊</span></h2>
<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>的频率比较高，<span style="color: black;">商场</span>图表中<span style="color: black;">运用</span>频率较低（太花里胡哨，<span style="color: black;">不足</span>简洁）</p>
<h2 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">3、</span>绘图<span style="color: black;">过程</span></h2>
<h3 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">第1</span>步，添加辅助列，并且将辅助列<span style="color: black;">所有</span>设置为1；</h3>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-df25da2a45249c1c76228c34dacf7be1_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">辅助列的值1：<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>
<h3 style="color: black; text-align: left; margin-bottom: 10px;">第二步，绘制簇状柱形图，设置系列重叠，将形状粘贴至数据系列中；</h3>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（1）全选数据，<span style="color: black;">插进</span>簇状柱形图。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（2）任意区域，<span style="color: black;">插进</span>两个一模<span style="color: black;">同样</span><span style="color: black;">体积</span>的正圆；一个圆做鱼缸（设置格式：<span style="color: black;">没</span>填充、线条为3磅），一个圆做水。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">效果如下：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic4.zhimg.com/80/v2-cab42020ce7b9020d1156f9d6e437c5f_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（3）选中鱼缸（圆环），Ctrl+C复制一下，再选中“辅助列”数据系列，Ctrl+V 粘贴。<span style="color: black;">一样</span>的操作，选中水（实心圆），Ctrl+C复制一下，再选中“完成率”数据系列，Ctrl+V 粘贴。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic2.zhimg.com/80/v2-c03166f9df109ab0d2fafcd176906269_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<h3 style="color: black; text-align: left; margin-bottom: 10px;">第三步，添加数据标签，<span style="color: black;">调节</span><span style="color: black;">体积</span>，让数据系列变成正圆形；</h3>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-6efc460fd200748554aa26a99b89e744_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">再设置系列重叠</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic3.zhimg.com/80/v2-c2ef9cf366582752806bca72d644f782_720w.webp" 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://pic1.zhimg.com/80/v2-34ab9ff2ba5d549af139531f95099d8c_720w.webp" 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>间距，慢慢让其变成正圆！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic3.zhimg.com/80/v2-03a3306746452767b0d27272454a1286_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">最后，再做一下美化图表（添加数据标签等）！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://pic1.zhimg.com/80/v2-b03e2863bb5b68ec7423f621c42ab6e4_720w.webp" style="width: 50%; margin-bottom: 20px;"></div>
祝福你、祝你幸福、早日实现等。 百度seo优化论坛 http://www.fok120.com/ 楼主的文章非常有意义，提升了我的知识水平。 我深受你的启发，你的话语是我前进的动力。 谷歌外链发布 http://www.fok120.com/ 外贸B2B平台有哪些？
页:
[1]