鼠目春光 發表於 2020-4-22 00:00:00

(视频)WPS表格新手入门课:如何绘制饼图

<b>视频地址1:</b>点击观看<br><br>
<b>视频地址2:</b>点击观看<br><br>
<b>教程难度:</b>初级<br><br>
<b>图文教程:</b><br>
<p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">饼图</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">是表格常见的图表样式之一,它可以直观的查看数据占比关系。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">那如何绘制表格</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">饼图</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">呢?</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bccf8f501a092ee62d67745e209abab1.png" title="教程分界线.png" alt="教程分界线.png"></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">以此表格为例,想要绘制此表数据的</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">饼图</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">选中表格数据单元格,点击上方菜单栏插入</span>-<span style="font-family:汉仪正圆-55W">全部图表</span><span style="font-family:Times New Roman">-</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">饼图</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">选择</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">饼图</span></span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">样式,点击插入。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/1081d5c1c4d0f351f46feb5f80f4d485.gif" title="2.gif" alt="2.gif"></span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">若我们想在饼图中插入对应数据标签,该怎么操作呢?</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">点击图表工具</span>-<span style="font-family:汉仪正圆-55W">添加元素</span><span style="font-family:Times New Roman">-</span><span style="font-family:汉仪正圆-55W">数据标签,选择样式,点击即可添加。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><br></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><img src="//res1.wpsacdm.cache.wpscdn.cn/images/912cf5a27f7e8824cda716bc70f0a779.gif" title="1.gif" alt="1.gif"></span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W"><br></span></span></p><p><span style=";font-family:微软雅黑;font-size:16px">▪</span><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">如何将饼图中的数据标签以百分比形式展现呢?</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">双击饼图中的数据标签,在右侧属性框中选择标签选项</span>-<span style="font-family:汉仪正圆-55W">标签。</span></span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">在标签选项中,取消勾选</span>“值”,并勾选“百分比”。</span></p><p><span style=";font-family:汉仪正圆-55W;font-size:16px"><span style="font-family:汉仪正圆-55W">这样就能显示饼图数据百分比了。</span></span></p><p><br></p><p><img src="//res1.wpsacdm.cache.wpscdn.cn/images/42a6b2af5b87f98e6c8d5a81caecacc1.gif" title="3.gif" alt="3.gif"></p>
頁: [1]
查看完整版本: (视频)WPS表格新手入门课:如何绘制饼图