中国地图最强Excel版.xls
- 文档编号:232979
- 上传时间:2022-10-07
- 格式:XLS
- 页数:180
- 大小:721KB
中国地图最强Excel版.xls
《中国地图最强Excel版.xls》由会员分享,可在线阅读,更多相关《中国地图最强Excel版.xls(180页珍藏版)》请在冰豆网上搜索。
中国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#N/A#N/A=OFFSET(Data!
$A$1,1,5*(List!
$F$1-1)+2,34,1)=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),)&I
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 中国地图 最强 Excel