EXCEL中国地图

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

中国ChartTitle1安徽省ShowCitySignTRUE北京市ShowCityNameTRUE重庆市福建省ShowDataTRUE甘肃省广东省ChartName=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+2,34,1)广西壮族自治区ChartX=OFFSET(Data!$A$1,1,5*(List!$F$1-1),1323,1)贵州省ChartX2=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+3,34,1)海南省ChartY=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+1,1323,1)河北省ChartY2=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+4,34,1)黑龙江省CN_1=IF(ShowCityName,OFFSET(ChartName,0,0,1,1),)&IF(ShowData,(&Input!$D$4&),)河南省CN_10=IF(ShowCityName,OFFSET(ChartName,9,0,1,1),)&IF(ShowData,(&Input!$D$13&),)湖北省CN_11=IF(ShowCityName,OFFSET(ChartName,10,0,1,1),)&IF(ShowData,(&Input!$D$14&),)湖南省CN_12=IF(ShowCityName,OFFSET(ChartName,11,0,1,1),)&IF(ShowData,(&Input!$D$15&),)江苏省CN_13=IF(ShowCityName,OFFSET(ChartName,12,0,1,1),)&IF(ShowData,(&Input!$D$16&),)江西省CN_14=IF(ShowCityName,OFFSET(ChartName,13,0,1,1),)&IF(ShowData,(&Input!$D$17&),)吉林省CN_15=IF(ShowCityName,OFFSET(ChartName,14,0,1,1),)&IF(ShowData,(&Input!$D$18&),)辽宁省CN_16=IF(ShowCityName,OFFSET(ChartName,15,0,1,1),)&IF(ShowData,(&Input!$D$19&),)内蒙古自治区CN_17=IF(ShowCityName,OFFSET(ChartName,16,0,1,1),)&IF(ShowData,(&Input!$D$20&),)宁夏回族自治区CN_18=IF(ShowCityName,OFFSET(ChartName,17,0,1,1),)&IF(ShowData,(&Input!$D$21&),)青海省CN_19=IF(ShowCityName,OFFSET(ChartName,18,0,1,1),)&IF(ShowData,(&Input!$D$22&),)山东省CN_2=IF(ShowCityName,OFFSET(ChartName,1,0,1,1),)&IF(ShowData,(&Input!$D$5&),)上海市CN_20=IF(ShowCityName,OFFSET(ChartName,19,0,1,1),)&IF(ShowData,(&Input!$D$23&),)陕西省CN_21=IF(ShowCityName,OFFSET(ChartName,20,0,1,1),)&IF(ShowData,(&Input!$D$24&),)山西省CN_22=IF(ShowCityName,OFFSET(ChartName,21,0,1,1),)&IF(ShowData,(&Input!$D$25&),)四川省CN_23=IF(ShowCityName,OFFSET(ChartName,22,0,1,1),)&IF(ShowData,(&Input!$D$26&),)台湾省CN_24=IF(ShowCityName,OFFSET(ChartName,23,0,1,1),)&IF(ShowData,(&Input!$D$27&),)天津市CN_25=IF(ShowCityName,OFFSET(ChartName,24,0,1,1),)&IF(ShowData,(&Input!$D$28&),)新疆维吾尔自治区CN_26=IF(ShowCityName,OFFSET(ChartName,25,0,1,1),)&IF(ShowData,(&Input!$D$29&),)西藏自治区CN_27=IF(ShowCityName,OFFSET(ChartName,26,0,1,1),)&IF(ShowData,(&Input!$D$30&),)云南省CN_28=IF(ShowCityName,OFFSET(ChartName,27,0,1,1),)&IF(ShowData,(&Input!$D$31&),)浙江省CN_29=IF(ShowCityName,OFFSET(ChartName,28,0,1,1),)&IF(ShowData,(&Input!$D$32&),)CN_3=IF(ShowCityName,OFFSET(ChartName,2,0,1,1),)&IF(ShowData,(&Input!$D$6&),)CN_30=IF(ShowCityName,OFFSET(ChartName,29,0,1,1),)&IF(ShowData,(&Input!$D$33&),)CN_31=IF(ShowCityName,OFFSET(ChartName,30,0,1,1),)&IF(ShowData,(&Input!$D$34&),)CN_32=IF(ShowCityName,OFFSET(ChartName,31,0,1,1),)&IF(ShowData,(&Input!$D$35&),)CN_33=IF(ShowCityName,OFFSET(ChartName,32,0,1,1),)&IF(ShowData,(&Input!$D$36&),)CN_34=IF(ShowCityName,OFFSET(ChartName,33,0,1,1),)&IF(ShowData,(&Input!$D$37&),)CN_4=IF(ShowCityName,OFFSET(ChartName,3,0,1,1),)&IF(ShowData,(&Input!$D$7&),)CN_5=IF(ShowCityName,OFFSET(ChartName,4,0,1,1),)&IF(ShowData,(&Input!$D$8&),)CN_6=IF(ShowCityName,OFFSET(ChartName,5,0,1,1),)&IF(ShowData,(&Input!$D$9&),)CN_7=IF(ShowCityName,OFFSET(ChartName,6,0,1,1),)&IF(ShowData,(&Input!$D$10&),)CN_8=IF(ShowCityName,OFFSET(ChartName,7,0,1,1),)&IF(ShowData,(&Input!$D$11&),)CN_9=IF(ShowCityName,OFFSET(ChartName,8,0,1,1),)&IF(ShowData,(&Input!$D$12&),)List=List!$A$1:$A$33ShowCityName=List!$F$3ShowData=List!$F$5#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+2,34,1)#N/A#N/A=OFFSET(Data!$A$1,1,5*(List!$F$1-1),1323,1)=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+3,34,1)=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+1,1323,1)=OFFSET(Data!$A$1,1,5*(List!$F$1-1)+4,34,1)=IF(ShowCityName,OFFSET(ChartName,0,0,1,1),)&IF(ShowData,(&Input!$D$4&),)=IF(ShowCityName,OFFSET(ChartName,9,0,1,1),)&IF(ShowData,(&Input!$D$13&),)=IF(ShowCityName,OFFSET(ChartName,10,0,1,1),)&IF(ShowData,(&Input!$D$14&),)=IF(ShowCityName,OFFSET(ChartName,11,0,1,1),)&IF(ShowData,(&Input!$D$15&),)=IF(ShowCityName,OFFSET(ChartName,12,0,1,1),)&IF(ShowData,(&Input!$D$16&),)=IF(ShowCityName,OFFSET(ChartName,13,0,1,1),)&IF(ShowData,(&Input!$D$17&),)=IF(ShowCityName,OFFSET(ChartName,14,0,1,1),)&IF(ShowData,(&Input!$D$18&),)=IF(ShowCityName,OFFSET(ChartName,15,0,1,1),)&IF(ShowData,(&Input!$D$19&),)=IF(ShowCityName,OFFSET(ChartName,16,0,1,1),)&IF(ShowData,(&Input!$D$20&),)=IF(ShowCityName,OFFSET(ChartName,17,0,1,1),)&IF(ShowData,(&Input!$D$21&),)=IF(ShowCityName,OFFSET(ChartName,18,0,1,1),)&IF(ShowData,(&Input!$D$22&),)=IF(ShowCityName,OFFSET(ChartName,1,0,1,1),)&IF(ShowData,(&Input!$D$5&),)=IF(ShowCityName,OFFSET(ChartName,19,0,1,1),)&IF(ShowData,(&Input!$D$23&),)=IF(ShowCityName,OFFSET(ChartName,20,0,1,1),)&IF(ShowData,(&Input!$D$24&),)=IF(ShowCityName,OFFSET(ChartName,21,0,1,1),)&IF(ShowData,(&Input!$D$25&),)=IF(ShowCityName,OFFSET(ChartName,22,0,1,1),)&IF(ShowData,(&Input!$D$26&),)=IF(ShowCityName,OFFSET(ChartName,23,0,1,1),)&IF(ShowData,(&Input!$D$27&),)=IF(ShowCityName,OFFSET(ChartName,24,0,1,1),)&IF(ShowData,(&Input!$D$28&),)=IF(ShowCityName,OFFSET(ChartName,25,0,1,1),)&IF(ShowData,(&Input!$D$29&),)=IF(ShowCityName,OFFSET(ChartName,26,0,1,1),)&IF(ShowData,(&Input!$D$30&),)=IF(ShowCityName,OFFSET(ChartName,27,0,1,1),)&IF(Show

1 / 172
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功