玩转WPS表格 - 自定义样式图表模板
<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 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></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;">图 17 - 24 所示，是某厨电<span style="color: black;">营销</span><span style="color: black;">机构</span> 2019 年度<span style="color: black;">区别</span>商品的<span style="color: black;">营销</span><span style="color: black;">目的</span>与<span style="color: black;">实质</span>完成率数据。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/4f0a9b19ab774cbb8caee3a379d98400~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=U8k2YNfsras9CPR%2BTCmmSwQS6O4%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 style="color: black;">17-24 <span style="color: black;">营销</span><span style="color: black;">目的</span>与<span style="color: black;">实质</span>完成率</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 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>如下。</span></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>一</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击数据区域任意单元格，如A 3 单元格，在【<span style="color: black;">插进</span>】选项卡下依次单击【<span style="color: black;">插进</span>组合图】→【簇状柱形图—次坐标轴上的折线图】命令，如图 17 - 25 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/12333c0e25074cf486fb003430dacdc8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=Y9aWK5HZETzUgftMgKQcfw2xKDo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-25 <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;"><strong style="color: blue;"><span style="color: black;">过程</span>二</strong></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>间距】选项下的文本框中输入 70 %，<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>间距，使各柱形之间的距离更加紧密。如图 17 - 26 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c2fe393d018341b09461b262a79d88ca~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=bSH7l7OAitehjjbIPG0UWTuISuI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-26 <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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>三</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击图表中的折线，选中“完成率”数据系列，在【属性】任务窗格中切换到【系列】→ 【系列选项】区域下，勾选【平滑线】复选框，如图 17 - 27 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/30c1965d0b7a45ff9bed194ced6730af~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=mEHgNOdHudEH4%2FH%2BPll7NTjdBJU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-27 设置平滑线</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>四</strong></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>设置为 8。如图 17 - 28 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/f9e5cca6063440f4bb64a75d1e03beac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=VVPzDLC1S4ZFNTbvV9KWUm3g60g%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-28 设置数据标记类型和<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;"><strong style="color: blue;"><span style="color: black;">过程</span>五</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击纵坐标轴，在【属性】任务窗格中切换到【坐标轴选项】→【坐标轴】→【坐标轴选项】区域，在【单位】下方的【<span style="color: black;">重点</span>】文本框中输入 300，如图 17 - 29 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1ecec9d109914c21a82fd8e33bea171a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=Kgt3AXioTwxGh9%2F451sBDcHrZfE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-29 设置纵坐标轴</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>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>六</strong></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>，复制后粘贴到WPS表格中。选中需要应用颜色<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>将该颜色应用到所选的图表元素上，如图 17 - 30 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/36084aa6b6854243aec4a70566f31e46~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=hNIbWbWSIDtxWih7B7s%2B6TGq9ss%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-30 <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;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>七</strong></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>取色器功能，对图表区、“完成率”系列的填充颜色进行设置。将图表标题修改为“2019年各商品<span style="color: black;">营销</span><span style="color: black;">目的</span>与完成率”，再拖动图表区外侧的<span style="color: black;">掌控</span>点，适当<span style="color: black;">调节</span>图表比例。效果如图 17 - 31 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/09103fc0f0b44b9e974c9cef66301af6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=JPF50u4lgY5pThsz2USLavT5L%2FI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-31 应用配色<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;"><strong style="color: blue;"><span style="color: black;">过程</span>八</strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击任意网格线，在【绘图工具】选项卡下单击【轮廓】下拉按钮，在下拉菜单中依次设置主题颜色为白色，设置线条样式为 1.5 磅，如图 17 - 32 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/43b2e9bdf9454ffe9baa19e2b94bc78a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=B3JGI%2FrMRZkQJTHLqaef07z0daY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-32 设置网格线轮廓颜色与线条样式</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>九</strong></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>为1.5磅，单击【确定】按钮，如图17-33所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/38932ac9c03f4101bac427bb432c07fc~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=eD6SWVtunWqweuNFjK8B3bUhYYE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-33 设置图表标题字符间距</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">设置完成后的图表效果如图 17 - 34 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/d87eb9e32e2940c1aa1ee6229d91dbc0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=Pq09gDkColdM35L3597OI6%2FzHU8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-34 <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;"><strong style="color: blue;"><span style="color: black;">过程</span>十</strong></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>】按钮，如图 17 - 35 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/6a0e44b843804173be1f3898be8e90e4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=LEDVv3PeqWYYYsk4gzNrbi3ARbM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-35 另存为模板</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">过程</span>十一</strong></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>单击数据区域任意单元格，如A 3 单元格，<span style="color: black;">而后</span>依次单击【<span style="color: black;">插进</span>】→【图表】按钮，弹出【<span style="color: black;">插进</span>图表】对话框。切换到【模板】选项卡下，单击选中预览界面的【组合图表】类型，最后单击【确定】按钮，如图 17 - 36 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c0a79dcba6bc453788f7a3eed7585034~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=gV7wceVtWP8BNZ%2B%2FhFWjZgpLwkE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-36 <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>，如 图 17 - 37 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/pgc-image/34ebd7faac254c9aa3f2d61c3ca9be5a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=VHoJ%2Fu8Gt0Xbt%2BLNaoEb6G66Ry8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">图 17-37 <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>会使你的效率倍增！</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;"><span style="color: black;"><strong style="color: blue;">《WPS表格实战技巧精粹》</strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p6-sign.toutiaoimg.com/pgc-image/b03f950f443845089fc745a44b1a4fd1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1728354041&x-signature=bns8wrzdny6EkVENlxzH5H2Wefg%3D" style="width: 50%; margin-bottom: 20px;"></div>
你的努力一定会被看见，相信自己，加油。 谷歌网站排名优化 http://www.fok120.com/ 系统提示我验证码错误1500次 ＼~゛，
页:
[1]