好看的图表用函数做，Excel rept重复字符串运用教程，制作五星好评，项目工作任务计划进度完成条形图怎么做
<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>年<span style="color: black;">一块</span>打过的卡</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">1、30天玩转数据透视表(已<span style="color: black;">保持</span>打卡30天)</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><span style="color: black;">2、80个必学必会Excel常用函数教程合集(已<span style="color: black;">保持</span>打卡12天)</span></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">3、好看好用的图表50篇（已<span style="color: black;">保持</span>打卡50天）</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">4、Excel<span style="color: black;">有效</span>办公技巧52招(已<span style="color: black;">保持</span>打卡52天)</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">5、Power Query 15天速成营(已<span style="color: black;">保持</span>打卡15天)</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">6、表格模板（已更</a>新13套）</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;">80个必学必会Excel常用函数</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">第12天 Rept重复函数</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">技巧1：rept函数用法教程</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">技巧2：Excel制作五星级<span style="color: black;">评估</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">技巧3：项目管理工作任务计划进度完成条形图怎么做</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">练习软件：office Excel 2016</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">01</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;">文本重复函数Rept</span></span></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/Ljib4So7yuWiaeZ0y9ice3mhnXTZHMOLf2ibEOsRUzwRFd9vtZDJg5QkJy98bryPria5Imw6LyWDGJowYjhtnGpia9Xw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">微软官方的介绍里，rept函数<span style="color: black;">便是</span>简单地将指定的文本重复相应的次数，</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">语法结构：REPT(需要重复<span style="color: black;">表示</span>的文本, 用于指定文本重复次数的正数)，<span style="color: black;">仅有</span>两个必需参数，<span style="color: black;">倘若</span> number_times 为 0（零），则 REPT 返回 ""（空文本）。<span style="color: black;">倘若</span> number_times 不是整数，将被截尾取整。</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>在replace替换函数里展示过了，需要的<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>、任务计划进度完成条形图。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIEJh22QuzWxJDeFqs34O6TdtglGpup0Th7uhEowwiaMn7gibR3lyapN6uuOIxnm8D1xwTF2xzq8PXnA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">02</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;">Excel制作五星级<span style="color: black;">评估</span></span></span></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/Ljib4So7yuWiaeZ0y9ice3mhnXTZHMOLf2ibEOsRUzwRFd9vtZDJg5QkJy98bryPria5Imw6LyWDGJowYjhtnGpia9Xw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> <span style="color: black;">Rept函数非常规<span style="color: black;">运用</span>的<span style="color: black;">第1</span>个场景<span style="color: black;">便是</span>麻烦给个五星好评呗。</span><span style="color: black;"><span style="color: black;">按照</span>评分来给星，1到5分对应1星到5星。</span><span style="color: black;">公式是</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">“=REPT("★",ROUND(B2,0))&REPT("☆",5-ROUND(B2,0))”，前半部分实心星星<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">针对</span>带小数点的精确评分，rept函数是直接向下取整，<span style="color: black;">引起</span><span style="color: black;">显现</span>凑<span style="color: black;">不足</span>5颗星星的<span style="color: black;">状况</span>，<span style="color: black;">因此</span>咱们用了round函数对数据进行四舍五入取整处理。<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 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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba8SsdIBpjiatHfenykEK803N0OWaYzglmibyhHhK0hZHMlD3uJ0LNlZQFg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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>重要，<span style="color: black;">便是</span>文本五角</span>星<span style="color: black;">怎么输入。</span><span style="color: black;"><span style="color: black;">举荐</span><span style="color: black;">运用</span>搜狗输入法的特殊符号。</span><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>键盘“Win键”和".键”,调出系统自带的表情符号来输入，<span style="color: black;">不外</span><span style="color: black;">仅有</span>实心的。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba8AmDRo08W1VtHL9C79q0d2HiaglGZpibzhAt5jrPmV23nqWtibibuWrQLFg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">03</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 style="color: black;">工作任务计划完成进度条形图</span></span></span></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/Ljib4So7yuWiaeZ0y9ice3mhnXTZHMOLf2ibEOsRUzwRFd9vtZDJg5QkJy98bryPria5Imw6LyWDGJowYjhtnGpia9Xw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<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>偏离度来<span style="color: black;">调节</span>数据条的颜色，<span style="color: black;">少于</span>0为红色，说明进度滞后，其他为绿色，说明按计划完成或超额完成。还有一个小细节<span style="color: black;">便是</span>，rept函数输出的结果看着是图表，<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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（1）话不多说，<span style="color: black;">起始</span>干活。先在F列输入公式“=REPT("|",D3*100)”，<span style="color: black;">按照</span>完成度数据<span style="color: black;">体积</span>，来决定文本“|”重复次数，源数据列最大数据<span style="color: black;">亦</span>不会超过1，<span style="color: black;">根据</span>向下取整规则，rept函数返回空文本，<span style="color: black;">因此</span>得乘以100。是不是很疑惑，这一堆数线和条形图怎么看<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba8ib3W3TjrWxpdAfXIw73I7gANJIiaCkJezJlBGSL3MKDJMbc3KQk8ZSkw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> （2）设置playbill字体。设置单元格字体格式为“Playbill”，再顺手<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba8iaGN5kErl9aBfTRy62XlQNg99wxTnJA26NL0rT2DQoDLJT68IpqOiaDQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">（3）<span style="color: black;">要求</span>格式设置进度偏离值<span style="color: black;">少于</span>0时，字体颜色为红色。<span style="color: black;">此刻</span>，该是各位心心念念的<span style="color: black;">要求</span>格式登场了，规则类型是“<span style="color: black;">运用</span>公式来确定要设置单元格格式的单元格”，公式是“$E3<0”，意思当E列单元格数据<span style="color: black;">少于</span>0时，字体颜色设置为红色；否则，还是绿色。</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>备用。顺便问一下自己，夏天过完了，年初立的减肥flag都实现了吗？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba86IawtHU5PUwuTY7zqGyJPC2lDksYLvvrNicEpdyKIB6jItnxGmiaesxA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">04</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></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/Ljib4So7yuWiaeZ0y9ice3mhnXTZHMOLf2ibEOsRUzwRFd9vtZDJg5QkJy98bryPria5Imw6LyWDGJowYjhtnGpia9Xw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"> 除了咱们今天用的Playbill字体，Excel表格中能和rept函数产生梦幻联动的字体还有<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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/GCEv3IwJAIFnpP5PC3dQkV1o9pYdgba8VwIaH0dGP0xyRS5AfvX45NMDno6v4XiaqBlZmuEorUxNgTMFCJggLpg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
你的话语如春风拂面，让我心生暖意。
页:
[1]