首页 map[addtime:<nil> column:0 data:{"status":0,"msg":"","data":{"data":{"banner":[{"image":"/assets/upload/2024/10/09/8321b9b943cd4f57fe891334012bebb1.png","t1":"感恩有你,未来可期","t2":"","t3":"/p/2802"}],"name1":"新闻资讯"}}} data2:<nil> description:16年IT服务经验-全国服务电话:400-017-5181 featured: id:1 illustrate:新闻资讯 keywords:同创双子公司新闻, 同创双子,同创双子怎么样,同创双子公司,成都同创双子,北京同创双子,同创双子最新新闻 name:新闻资讯 orders:1 state:true tag:<nil> templateslist:{ "controls": [ { "name": "data.name1", "label": "简单标题", "type": "input-text" }, { "type": "combo", "name": "data.banner", "label": "轮播", "multiple": true, "draggable": true, "items": [ { "name": "t1", "label": "标题", "type": "input-text" }, { "name": "t2", "label": "时间", "type": "input-text" }, { "name": "t3", "label": "连接", "type": "input-text" }, { "type": "input-image", "name": "image", "label": "配图", "receiver": "./api/upload?rich=2" } ] } ] } templatespage:{ "controls": [ { "label": "推荐等级", "type": "select", "name": "featured", "options": [ { "label": "不推荐", "value": 0 }, { "label": "首页推荐", "value": 1001 } ] }, { "type": "group", "body": [ { "name": "data.listimg", "label": "列表图片", "receiver": "./api/upload?rich=2", "type": "input-image" }, { "name": "data.img", "label": "首页图片", "receiver": "./api/upload?rich=2", "type": "input-image" } ] }, { "type": "input-rich-text", "name": "data.body", "label": "文章内容1", "receiver": "post:./api/upload?rich=1" } ] } title:新闻资讯-同创双子(北京)信息技术股份有限公司 tmpllist:list tmplpage:page url:news] > 新闻资讯 map[addtime:<nil> column:1 data:{"status":0,"msg":"","data":{"data":{"banner":[{"image":"/assets/upload/2023/12/13/3e1643bd17c60956f27ddf735eb3048d.png","t1":"桌面运维是什么?外包好还是自招好","t3":"https://www.itgemini.net/p/2613"},{"image":"/assets/upload/2023/12/13/d52a5f367538356cbcbfbbf727a5e0a7.png","t1":"什么是系统集成?同创双子可以做哪些系统集成服务","t3":"https://www.itgemini.net/p/2611"}],"name1":"干货分享"}}} data2:<nil> description:16年IT服务经验-全国服务电话:400-017-5181 featured: id:3 illustrate:干货分享 keywords:同创双子公司新闻, 同创双,同创双子公司,成都同创双子,北京同创双子,同创双子最新新闻,电脑卡顿,电脑故障,网络故障 name:干货分享 orders:1 state:true tag:<nil> templateslist:{ "controls": [ { "name": "data.name1", "label": "简单标题", "type": "input-text" }, { "type": "combo", "name": "data.banner", "label": "轮播", "multiple": true, "draggable": true, "items": [ { "name": "t1", "label": "标题", "type": "input-text" }, { "name": "t2", "label": "时间", "type": "input-text" }, { "name": "t3", "label": "连接", "type": "input-text" }, { "type": "input-image", "name": "image", "label": "配图", "receiver": "./api/upload?rich=2" } ] } ] } templatespage:{ "controls": [ { "label": "推荐等级", "type": "select", "name": "featured", "options": [ { "label": "不推荐", "value": 0 }, { "label": "首页推荐", "value": 1001 } ] }, { "type": "group", "body": [ { "name": "data.listimg", "label": "列表图片", "receiver": "./api/upload?rich=2", "type": "input-image" }, { "name": "data.img", "label": "首页图片", "receiver": "./api/upload?rich=2", "type": "input-image" } ] }, { "type": "input-rich-text", "name": "data.body", "label": "文章内容", "receiver": "post:./api/upload?rich=1" } ] } title:干货分享-IT技巧-同创双子(北京)信息技术股份有限公司 tmpllist:list tmplpage:page url:share] > 干货分享
年终总结时间到,专业IT运维服务商教你做领导喜欢的动态报表

发布日期:2020/12/17 08:00:00

年关将至,有的人狂冲业绩,坐等年终奖,有的人可能正被年终总结折磨……

年终工作总结,少不了借助表格进行工作数据的处理和分析,掌握一些excel数据展示技巧,将会大大提高我们在别人心中的印象。

今天就教你制作下拉式动态图表:

下拉菜单式图表,最终效果图如下:

4.gif

首先,我们需要先准备一组数据:

步骤一:创建辅助列

在A9单元格中输入1, 在B9单元格中输入公式:

=INDEX(B3:B10,$A$9,1),并向右填充,如下动图所示。

1.gif

步骤二:绘制组合框

点击菜单栏【开发工具】-【插入】-【组合框】,选择组合框点击鼠标右键,打开【设置控件格式】。

【数据源区域】为“$A$3:$A$8”()

【单元格链接】为“$A$9”

【下拉显示项】为“7”(根据实际下拉项来设置)

单击【确定】按钮,如下图所示。

2.gif

步骤三:插入柱状图

选择B2:D2和B9:D9单元格区域,点击菜单的【插入】-【插入柱状图】,如下图所示。

3.gif

步骤四:美化和修饰图表

通过以上步骤图表已经基本完成,最后可对控件位置进行调整,使其适合阅读报表的习惯,并且对图表配色等进行 美化就可以了。

4.gif

怎么样是不是很简单就能让你的数据变的不一样了,以后在遇到复杂的数据,就可以用动态图标展示了,让你的领导勾选关键指标查看动态展示,不但体验良好,还能彰显专业,好了,今天的分享就到这了,快来一起学习一下吧!

同创双子为企业保驾护航

专注数字化方案建设,推动智慧企业生态圈的升级发展