Excel常用技巧大全之用控件制作图表
<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>介绍<span style="color: black;">怎样</span>用vlookup函数制作智能化图表，下表是奋钧<span style="color: black;">机构</span>2013年到2016年的<span style="color: black;">营销</span>额（单位：百万）：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCPfMv1LwehribuU0xPLliaIiaA44VmkrgKpE3OwiczgbCbSYibYKEGf1bss9DcorjeYeOn6H6WR4msv9UA/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">下面，<span style="color: black;">咱们</span>在地区的左列输入序号，在表的行标题下再<span style="color: black;">插进</span>一行，并在C3单元格输入公式=VLOOKUP($A$3,$A$4:$F$7,3,0)，依次在D3，E3，F3单元格输入公式=VLOOKUP($A$3,$A$4:$F$7,4,0)；=VLOOKUP($A$3,$A$4:$F$7,5,0)；=VLOOKUP($A$3,$A$4:$F$7,6,0)如下图所示：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCPfMv1LwehribuU0xPLliaIiaArQCMkyjVekkEfUgda7yjtLbKMW3YAu3pEHmYU1KE3H1egUScGr8f8A/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">之后，<span style="color: black;">咱们</span>在<span style="color: black;">研发</span>工具—<span style="color: black;">插进</span>—下拉框（窗体控件），并设置其格式：数据源区域<span style="color: black;">选取</span>B4：B7，单元格链接<span style="color: black;">选取</span>A3，<span style="color: black;">而后</span>确定，如下图所示：</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCPfMv1LwehribuU0xPLliaIiaALWuZY4vibhLo23lJsbHQgWf3KLiaa0GCF2nDuJ1NYiccx3cmP2Hkka8Sg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> <span style="color: black;">最后，<span style="color: black;">选择</span>区域C2：F3，<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCPfMv1LwehribuU0xPLliaIiaALzR5WmPq5ZFXLp4DpxLRDTS6R4OjIDbD6wialwzLJrf2dIwmf2BR1Ow/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCPfMv1LwehribuU0xPLliaIiaABQcqRvo89j1MDHtj51gLfK8o27AnjvWANdogmlO262So25hxywJTEg/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">您<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>您想学习其他知识，请扫描或长按并识别下图二维码，关注“Excel速成秘籍”公众号，精彩内容<span style="color: black;">持续</span>。（<span style="color: black;">亦</span>可点击<span style="color: black;">文案</span>最上方蓝色字“Excel速成秘籍”进行关注）</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/Xkvwmf8OyCMOJHicd6B6W73ukowVdCbVH4rahDsyn5bMXVYBecZEToYzjjyrxBiaF1Q4f3oUjzBIRcCUFyvpib0Cg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
页:
[1]