这个图表的怎么实现-突出显示选择的时间段
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzAxLzIxMDQvMjEzNTQ2Mzg4XzFfMjAyMTAxMjEwNDMyNDQ2NDc=.jpg)
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzAxLzIxMDQvMjEzNTQ2Mzg4XzJfMjAyMTAxMjEwNDMyNDUzMzQ=.jpg)
前面我们介绍过一个关于长时间数据的展示图表(详情看这里),那时,我们主要目标是看清某个时间点的数据。今天我们介绍针对这种数据的另外一种交互式展示方法:
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzAxLzIxMDQvMjEzNTQ2Mzg4XzNfMjAyMTAxMjEwNDMyNDU0NDQ=.jpg)
通过切片器选择不同的年份,可以在图表中高亮显示相应年份的数据。
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzAxLzIxMDQvMjEzNTQ2Mzg4XzJfMjAyMTAxMjEwNDMyNDUzMzQ=.jpg)
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHBzL2ltYWdlMTA5LjM2MGRvYy5jbi9Eb3dubG9hZEltZy8yMDIxLzAxLzIxMDQvMjEzNTQ2Mzg4XzRfMjAyMTAxMjEwNDMyNDYzNjY=.jpg)
原始数据如下图:
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHAvaW1hZ2UxMDkuMzYwZG9jLmNuL0Rvd25sb2FkSW1nLzIwMjEvMDEvMjEwNC8yMTM1NDYzODhfNV8yMDIxMDEyMTA0MzI0NzEwNQ==.jpg)
在这个图表上,插入数据透视表:
![](http://pic.ikafan.com/imgp/L3Byb3h5L2h0dHAvaW1hZ2UxMDkuMzYwZG9jLmNuL0Rvd25sb2FkSW1nLzIwMjEvMDEvMjEwNC8yMTM1NDYzODhfNl8yMDIxMDEyMTA0MzI0NzMwMw==.jpg)
在数据透视表-分析选项卡中,点击“合计”,去掉行列合计:
![](http://n4.ikafan.com/assetsj/blank.gif)
针对透视表,添加几个辅助值:
![](http://n4.ikafan.com/assetsj/blank.gif)
定义名称:BeginDate,EndDate,MaxValue分别对应这里的E2,E3,E4单元格。
添加作图的辅助数据:
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
选中数据区域,在“插入”选项卡中点击插入折线图:
![](http://n4.ikafan.com/assetsj/blank.gif)
得到图表:
![](http://n4.ikafan.com/assetsj/blank.gif)
去掉标题和图例:
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
在图表上点击鼠标右键,点击“更改系列图表类型”:
![](http://n4.ikafan.com/assetsj/blank.gif)
将“背景”系列修改为簇状柱形图:
![](http://n4.ikafan.com/assetsj/blank.gif)
得到图表:
![](http://n4.ikafan.com/assetsj/blank.gif)
选中系列“数量”(蓝色折线),修改其线条为灰色,线宽为1:
![](http://n4.ikafan.com/assetsj/blank.gif)
修改“背景”系列格式,将间隔宽度调整为0:
![](http://n4.ikafan.com/assetsj/blank.gif)
将填充颜色设置为黄色:
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
添加切片器
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
总结
![](http://n4.ikafan.com/assetsj/blank.gif)
关注本公众号,点击底部菜单“联系客服”,与客服取得联系,索取“加强展示选定时间段”案例文件
![](http://n4.ikafan.com/assetsj/blank.gif)
赞 (0)