首页 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] > 干货分享
汇报季|数据太多太杂乱?试试这种动态图表展示效果

发布日期:2020/11/26 08:00:00

又要到年终汇报的时刻了

相信不少小伙伴

在进行工作汇报的时候

总免不了制作各种图表


但是面对一堆数据

怎么呈现给领导呢?

怎么表现出自己的业绩呢?


想做好数据图表

我有一个动态图表制作技巧分享给你


复选框图表制作


效果如下图显示: 


4.gif


点击菜单栏的【开发者工具】-【插入】-选择【复选框】,复制出3个一样的复选框,并设置控件的属性,右键-【设置控件格式】,将其链接至任意一个单元格,再将复选框名称改为相应的名称即可。


1.gif

建立一个相同的辅助表格,将原有表格复制过来,里面的数据不用复制在空白表格内输入公式:=IF(E$2=TRUE,B2,"")


公式解释:当E2单元格显示为“TRUE”即复选框勾选时,单元格即显示为B2中数据。


2.gif

选中全部数据,点击【插入】-【图表】-【柱状图】。


3.gif


最后,完美主义者来一次图表美化,一份完美的动态图标就完成了。

 

4.gif


对于没有【开发工具】选项卡的小伙伴,可以在【文件】-【选项】-【自定义功能区】找到并添加即可。


微信图片_20201126142515.png


复选框式的动态图表制作分享结束了,方法很简单,但是却能让我们的数据展示效果提升百倍,快来一起动手试试吧!


9c7c5fcca75f4218bfeefbf7d949558a.jpg

同创双子为企业保驾护航

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