中国地图Excel版.xls

中国Chart Title1 安徽省Show City SignTRUE 北京市Show City NameTRUE 重庆市 福建省Show DataTRUE 甘肃省 广东省ChartNameOFFSETDataA1,1,5*ListF1-12,34,1 广西壮族自治区ChartXOFFSETDataA1,1,5*ListF1-1,1323,1 贵州省ChartX2OFFSETDataA1,1,5*ListF1-13,34,1 海南省ChartYOFFSETDataA1,1,5*ListF1-11,1323,1 河北省ChartY2OFFSETDataA1,1,5*ListF1-14,34,1 黑龙江省CN_1IFShowCityName,OFFSETChartName,0,0,1,1,““IFShowData,““D4““,““ 河南省CN_10IFShowCityName,OFFSETChartName,9,0,1,1,““IFShowData,““D13““,““ 湖北省CN_11IFShowCityName,OFFSETChartName,10,0,1,1,““IFShowData,““D14““,““ 湖南省CN_12IFShowCityName,OFFSETChartName,11,0,1,1,““IFShowData,““D15““,““ 江苏省CN_13IFShowCityName,OFFSETChartName,12,0,1,1,““IFShowData,““D16““,““ 江西省CN_14IFShowCityName,OFFSETChartName,13,0,1,1,““IFShowData,““D17““,““ 吉林省CN_15IFShowCityName,OFFSETChartName,14,0,1,1,““IFShowData,““D18““,““ 辽宁省CN_16IFShowCityName,OFFSETChartName,15,0,1,1,““IFShowData,““D19““,““ 内蒙古自治区CN_17IFShowCityName,OFFSETChartName,16,0,1,1,““IFShowData,““D20““,““ 宁夏回族自治区CN_18IFShowCityName,OFFSETChartName,17,0,1,1,““IFShowData,““D21““,““ 青海省CN_19IFShowCityName,OFFSETChartName,18,0,1,1,““IFShowData,““D22““,““ 山东省CN_2IFShowCityName,OFFSETChartName,1,0,1,1,““IFShowData,““D5““,““ 上海市CN_20IFShowCityName,OFFSETChartName,19,0,1,1,““IFShowData,““D23““,““ 陕西省CN_21IFShowCityName,OFFSETChartName,20,0,1,1,““IFShowData,““D24““,““ 山西省CN_22IFShowCityName,OFFSETChartName,21,0,1,1,““IFShowData,““D25““,““ 四川省CN_23IFShowCityName,OFFSETChartName,22,0,1,1,““IFShowData,““D26““,““ 台湾省CN_24IFShowCityName,OFFSETChartName,23,0,1,1,““IFShowData,““D27““,““ 天津市CN_25IFShowCityName,OFFSETChartName,24,0,1,1,““IFShowData,““D28““,““ 新疆维吾尔自治区CN_26IFShowCityName,OFFSETChartName,25,0,1,1,““IFShowData,““D29““,““ 西藏自治区CN_27IFShowCityName,OFFSETChartName,26,0,1,1,““IFShowData,““D30““,““ 云南省CN_28IFShowCityName,OFFSETChartName,27,0,1,1,““IFShowData,““D31““,““ 浙江省CN_29IFShowCityName,OFFSETChartName,28,0,1,1,““IFShowData,““D32““,““ CN_3IFShowCityName,OFFSETChartName,2,0,1,1,““IFShowData,““D6““,““ CN_30IFShowCityName,OFFSETChartName,29,0,1,1,““IFShowData,““D33““,““ CN_31IFShowCityName,OFFSETChartName,30,0,1,1,““IFShowData,““D34““,““ CN_32IFShowCityName,OFFSETChartName,31,0,1,1,““IFShowData,““D35““,““ CN_33IFShowCityName,OFFSETChartName,32,0,1,1,““IFShowData,““D36““,““ CN_34IFShowCityName,OFFSETChartName,33,0,1,1,““IFShowData,““D37““,““ CN_4IFShowCityName,OFFSETChartName,3,0,1,1,““IFShowData,““D7““,““ CN_5IFShowCityName,OFFSETChartName,4,0,1,1,““IFShowData,““D8““,““ CN_6IFShowCityName,OFFSETChartName,5,0,1,1,““IFShowData,““D9““,““ CN_7IFShowCityName,OFFSETChartName,6,0,1,1,““IFShowData,““D10““,““ CN_8IFShowCityName,OFFSETChartName,7,0,1,1,““IFShowData,““D11““,““ CN_9IFShowCityName,OFFSETChartName,8,0,1,1,““IFShowData,““D12““,““ ListListA1A33 ShowCityNameListF3 ShowDataListF5 N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A N/AN/A OFFSETDataA1,1,5*ListF1-11,1323,1 IFShowCityName,OFFSETChartName,0,0,1,1,““IFShowData,““D4““,““ IFShowCityName,OFFSETChartName,9,0,1,1,““IFShowData,““D13““,““ IFShowCityName,OFFSETChartName,10,0,1,1,““IFShowData,““D14““,““ IFShowCityName,OFFSETChartName,11,0,1,1,““IFShowData,““D15““,““ IFShowCityName,OFFSETChartName,12,0,1,1,““IFShowData,““D16““,““ IFShowCityName,OFFSETChartName,13,0,1,1,““IFShowData,““D17““,““ IFShowCityName,OFFSETChartName,14,0,1,1,““IFShowData,““D18““,““ IFShowCityName,OFFSETChartName,15,0,1,1,““IFShowData,““D19““,““ IFShowCityName,OFFSETChartName,16,0,1,1,““IFShowData,““D20““,““ IFShowCityName,OFFSETChartName,17,0,1,1,““IFShowData,““D21““,““ IFShowCityName,OFFSETChartName,18,0,1,1,““IFShowData,““D22““,““ IFShowCityName,OFFSETChartName,1,0,1,1,““IFShowData,““D5““,““ IFShowCityName,OFFSETChartName,19,0,1,1,““IFShowData,““D23““,““ IFShowCityName,OFFSETChartName,20,0,1,1,““IFShowData,““D24““,““ IFShowCityName,OFFSETChartName,21,0,1,1,““IFShowData,““D25““,““ IFShowCityName,OFFSETChartName,22,0,1,1,““IFShowData,““D26““,““ IFShowCityName,OFFSETChartName,23,0,1,1,““IFShowData,““D27““,““ IFShowCityName,OFFSETChartName,24,0,1,1,““IFShowData,““D28““,““ IFShowCityName,OFFSETChartName,25,0,1,1,““IFShowData,““D29““,““ IFShowCityName,OFFSETChartName,26,0,1,1,““IFShowData,““D30““,““ IFShowCityName,OFFSETChartName,27,0,1,1,““IFShowData,““D31““,““ IFShowCityName,OFFSETChartName,28,0,1,1,““IFShowData,““D32““,““ IFShowCityName,OFFSETChartName,2,0,1,1,““IFShowData,““D6““,““ IFShowCityName,OFFSETChartName,29,0,1,1,““IFShowData,““D33““,““ IFShowCityName,OFFSETChartName,30,0,1,1,““IFShowData,““D34““,““ IFShowCityName,OFFSETChartName,31,0,1,1,““IFShowData,““D35““,““ IFShowCityName,OFFSETChartName,32,0,1,1,““IFShowData,““D36““,““ IFShowCityName,OFFSETChartName,33,0,1,1,““IFShowData,““D37““,““ IFShowCityName,OFFSETChartName,3,0,1,1,““IFShowData,““D7““,““ IFShowCityName,OFFSETChartName,4,0,1,1,““IFShowData,““D8““,““ IFShowCityName,OFFSETChartName,5,0,1,1,““IFShowData,““D9““,““ IFShowCityName,OFFSETChartName,6,0,1,1,““IFShowData,““D10““,““ IFShowCityName,OFFSETChartName,7,0,1,1,““IFShowData,““D11““,““ IFShowCityName,OFFSETChartName,8,0,1,1,““IFShowData,““D12““,““ 城市名称数据 北京市12 安徽省23 重庆市2 福建省3 甘肃省5 广东省3 广西壮族自治区3 贵州省23 海南省4 河北省34 黑龙江省5 河南省6 湖北省7 湖南省4 江苏省3 江西省7 吉林省34 辽宁省23 内蒙古自治区22 宁夏回族自治区65 青海省45 山东省34 上海市34 陕西省23 山西省23 四川省6 台湾省54 天津市76 新疆维吾尔自治区43 西藏自治区32 云南省87 浙江省65 香港34 澳门23 本地图为纯Excel图表。 创作过程简述如下 1. 从网上下载中国地图及各省市地图，存为位图 2. 利用专门将位图转换为矢量图的软件，将各位图地图转换为矢量图和文本文件 （文本文件记录每个点的X和Y值） 3. 将文本文件里的数据导入Excel 4. 定义名称。请自己查看本文件里的名称按AltF11组合键进入VB编辑器，将工作表Data设置为可见。或者选择格式-工作表-取消隐藏。 激活工作表Data，选择菜单插入-名称-定义。 5. 给图表赋值。其它关于图表格式设置的问题请参见论坛帖子。 至此，你已窥视所有秘密了 显示城市名称显示数据显示城市标志 本地图为纯Excel图表。 创作过程简述如下 1. 从网上下载中国地图及各省市地图，存为位图 2. 利用专门将位图转换为矢量图的软件，将各位图地图转换为矢量图和文本文件 （文本文件记录每个点的X和Y值） 3. 将文本文件里的数据导入Excel 4. 定义名称。请自己查看本文件里的名称按AltF11组合键进入VB编辑器，将工作表Data设置为可见。或者选择格式-工作表-取消隐藏。 激活工作表Data，选择菜单插入-名称-定义。 5. 给图表赋值。其它关于图表格式设置的问题请参见论坛帖子。 至此，你已窥视所有秘密了 显示城市名称显示数据显示城市标志 中国安徽省北京市重庆市福建省 20.3 3.94 北京市15.4 10.4 15.74.6 合肥129 6.24 5.35 二环区11.6 6.11 9.95 6.79 市区10.68.2 16.4 20.2 4.01 安徽省166.7 15.5 4.46 淮北10.2 13.4 6.11 5.42 延庆县10.5 1210 6.56 万州14.4 12.5 16.6 204 重庆市12.45.5 15.3 4.36 宿州11.7 13.3 5.985.5 怀柔区12.811 10.1 6.45 三峡15.912 16.7 19.9 3.87 福建省17.24.2 15.2 4.26 亳州9.26 12.3 5.89 5.62 密云县15.6 11.6 10.1 6.36 北线9.59.4 16.8 19.8 3.72 甘肃省10.88.215 4.13 蚌埠12 11.7 5.895.7 昌平区10.59 10.2 6.15 大足石刻 8.18.3 16.8 20 3.62 广东省15.12.8 14.9 4.12 阜阳8.1 10.9 5.885.9 顺义区13.88.5 10.3 6.05 涪陵128.6 16.7 20.2 3.69 广西壮族自治区12.82.3 14.8 4.31 淮南10.5 10.9 5.85 6.07 平谷区16.68.7 10.4 6.16 南线10.1 7 20.3 3.81 贵州省12.44 14.8 4.39 滁州13 10.4 5.79 6.22 门头沟区 7.67 10.5 6.31 黔江13.57.9 16.7 20.3 3.94 海南省13.60.7 14.7 4.45 六安9.88.3 5.62 6.42 石景山区10.36.5 10.6 6.4616.9 河北省14.89.4 14.5 4.59 巢湖13.27.7 5.47 6.51 海淀区10.8 7.3 10.5 6.5917 20.1 4.21 黑龙江省18.3 13.4 14.4 4.72 马鞍山14.58.2 5.35 6.56 朝阳区12.6 6.6 10.7 6.65 20.2 4.41 河南省14.77.6 14.4 4.87 芜湖14.26.75.3 6.63 通州区144.716.9 20.3 4.57 湖北省15.25.9 14.4 5.02 铜陵13.26.4 5.36 6.83 房山区 8.24.3 10.7 6.6516.8 20.4 4.69 湖南省14.74.6 14.2 5.17 安庆10.65.4 5.44 7.02 大兴区11.64 10.6 6.46 江苏省176.614 5.22 池州12.54.8 5.53 7.1816.8 19.3 4.76 江西省164.9 13.95.3 宜城15.66.1 5.64 7.32 10.7 6.6516.7 19.4 4.53 吉林省18.2 12.3 13.6 5.31 黄山13.64 5.76 7.4310.8 6.7216.6 19.6 4.38 辽宁省17.4 11.35.89 7.5310.9 6.7916.4 19.74.3 内蒙古自治区14 10.7 13.9 5.786.04 7.6211.16.916.3 19.8 4.27 宁夏回族自治区11.99 14.1 5.886.2 7.71 16.1 20 4.25 青海省108.9 14.2 5.98 6.377.89.98 6.4915.9 20 4.23 山东省168.7 14.3 6.13 6.49 7.8810 6.5615.6 20.2 4.14 上海市17.86.5 14.5 6.166.63 7.9615.5 20.4 4.21 陕西省12.87.6 14.7 6.146.8 8.0210 6.5715.4 20.5 4.29 山西省149 14.7 6.176.95 8.05 9.96 6.4115.3 20.7 4.37 四川省10.86 14.7 6.297.1 8.079.89 6.2415.2 20.8 4.44 台湾省183.3 14.7 6.617.25 8.09 9.78 6.2115.1 20.9 4.47 天津市15.810 14.8 6.787.41 8.229.65 6.2815 21 4.49 新疆维吾尔自治区6 12.915 6.947.54 8.399.59 6.42 14.8 21.2 4.53 西藏自治区5.75.7 15.1 7.087.66 8.44 9.556.614.7 21.4 4.62 云南省10.3 2.8715 7.187.82 8.329.51 6.7714.6 21.6 4.76 浙江省17.46.2 14.9 7.277.98 8.289.45 6.9314.5 香港15.12.1 14.8 7.498.14 8.259.32 7.0214.4 224.8 澳门15.32.18.29 8.199.1 7.0714.4 22 4.5914.7 7.518.34 8.148.91 7.0814.3 22.1 4.4914.8 7.488.42 8.068.757.114.3 22.2 4.5215 7.468.52 7.968.63 7.1414.2 22.2 4.7315.17.48.66 7.858.57 7.2514.1 15.2 7.358.82 7.758.54 7.4813.9 18.3 3.7715.4 7.329 7.688.53 7.6313.8 18.3 3.6715.7 7.369.22 7.648.47 7.7713.7 18.3 3.4915.8 7.429.45 7.668.31 7.8513.6 18.3 3.2715.9 7.478.14 7.9113.5 18.3 3.0516.17.510.2 5.998.02 8.0413.3 18.2 2.8616.3 7.5110.1 6.167.89 8.2213.2 18.2 2.7516.5 7.479.92 6.357.79 8.3613.2 18.1 2.5816.5 7.389.83 6.537.8 8.5313.1 18.12.416.7 7.329.79 6.697.96 8.6713.1 18 2.2316.8 7.299.84 6.828.12 8.7813.1 17.8 2.3717 7.239.98 6.878.28 8.8813.1 17.72.517.1 7.1110.1 6.848.49 9.0713.1 17.7 2.6517.1 6.9110.3 6.758.69.213.1 17.62.817 6.7310.46.68.62 9.3113.2 17.6 2.9717 6.5310.5 6.448.59 9.4213.4 17.6 3.1316.9 6.3510.5 6.278.48 9.5713.5 17.7 3.2816.8 6.218.47 9.7613.4 17.8 3.4316.7 6.0910.1 6.868.54 9.9413.5 17.8 3.5716.6 5.9910.17.18.66 10.113.6 18 3.7416.5 5.8710 7.178.81 10.213.8 18.2 3.8316.5 5.749.87 7.248.98 10.213.9 18.3 3.7716.5 5.619.7 7.269.15 10.114.1 16.6 5.459.54 7.339.311014.3 17.7 4.6416.6 5.339.517.59.47 9.9114.5 17.4 4.6816.55.29.45 7.669.56 9.8214.6 17.3 4.7116.45.19.46 7.819.699.814.7 17.1 4.6716.2 5.069.64 7.959.86 9.8514.9 17 4.7416 5.089.84 8.0110 9.9115.1 16.9 4.8815.8 5.0710 8.0310.2 9.8615.2 16.7 5.0615.7 4.9710.2 8.1710.3 9.7315.4 15.7 4.8310.3 8.2810.4 9.5815.6 16.6 5.5815.7 4.5610.5 8.2210.5 9.4515.7 16.6 5.4215.7 4.3910.7 8.0410.6 9.3916 16.6 5.3415.8 4.2810.7 7.9110.8 9.3816.2 16.7 5.1515.8 4.1910.8 7.8210.9 9.4116.3 16.7 4.9815.7 4.0710.9 7.7311.1 9.4716.4 16.5 4.8815.6 3.8911 7.5911.2 9.5616.4 16.3 4.7815.5 3.6811.27.511.4 9.6616.3 16.2 4.6215.4 3.4911.4 7.5211.5 9.7816.1 16.2 4.3815.3 3.3811.6 7.45 16.1 4.2815.2 3.2211.6 7.2911.5 9.7816.1 16 4.1915 3.0711.7 7.3411.6 9.4216.3 16.1 4.0414.9 2.9311.8 7.3911.69.316.4 16 3.8914.72.811.97.511.6 9.3316.5 15.9 3.7114.6 2.6912.1 7.6311.5 9.4716.6 15.9 3.5214.4 2.6212.2 7.7811.5 9.6416.7 15.9 3.3614.3 2.5812.2 7.9611.5 9.7816.9 15.93.314.2 2.6412.3 8.1511.6 9.93 16.1 3.3314.1 2.7812.3 8.3211.7 10.116.5 16.2 3.2413.9 2.9212.28.511.8 10.416.5 16.3 3.1213.8 2.9312.2 8.6711.8 10.516.4 16.4 2.9713.6 2.9212.2 8.8311.9 10.7 16.5 2.7913.4 2.9112.3 8.9811.9 10.915.7 13.22.912.4 9.11121115.7 15.9 3.3113 2.9212.59.212.2 11.1 15.7 3.2612.9 2.9812.6 9.2712.3 11.115.4 15.6 3.2712.7 3.1312.8 9.2912.51115.6 15.43.212.6 3.3113 9.1812.61115.8 15.2 3.1112.5 3.4713.2 9.1512.7 11.116 15.23.212.4 3.5113.4 9.1412.8 11.216.1 15.3 3.3312.3 3.5213.5 8.9712.8 11.316.1 15.3 3.4412.23.613.6 9.0212.9 11.416 15.3 3.5412 3.8513.7 9.1513 11.615.8 15.1 3.5313.8 9.2713.1 11.815.8 11 3.9213.9 9.4113.2 12.1 15.1 3.5311.1 4.1314 9.5613.3 12.215.7 14.8 3.5111.2 4.2514 9.7813.3 12.415.7 14.7 3.4811.2 4.3713.8 9.9513.5 12.5 14.7 3.3211.3 4.5413.7 10.113.7 12.715.7 14.6 3.2611.4 4.6813.8 10.313.8 12.815.5 14.5 3.3311.3 4.8413.8 10.413.9 12.915.3 14.3 3.2811.3 4.9913.8 10.613.8 13.115.3 14.2 3.0811.55.113.7 10.913.7 13.115.5 11.6 5.1713.61113.5 13.215.6 15.1 3.5311.8 5.1613.6 11.113.5 13.415.7 15.13.711.9 5.1213.7 11.213.6 13.615.8 15 3.8712 5.2513.7 11.413.7 13.615.9 15 4.0312 5.4813.6 11.613.7 13.816.1 154.212 5.5913.5 11.713.7 13.9 14.9 4.3612.2 5.6813.9 13.916.1 14.9 4.5212.3 5.7213.5 11.714.1 13.916 15 4.7412.5 5.7913.6 11.714.1 13.815.8 15 4.8512.7 5.8813.7 11.814.2 13.815.7 15 4.9912.8 5.9613.71214.3 13.715.6 14.9 5.1913 6.0113.7 12.214.4 13.615.4 13.1 5.9813.7 12.414.6 13.515.3 13.1 3.5813.2 5.9913.7 12.614.9 13.315.3 13.1 3.7413.3 6.0913.7 12.715.1 13.215.5 13.1 3.8813.5 6.1513.8 12.815.21315.6 13.1 4.0213.66.114.11315.4 12.915.6 13 4.1713.8 5.9514.2 13.115.6 12.915.5 13 4.3113.9 5.7814.2 13.215.8 12.915.5 13.14.514.3 13.315.9 12.915.4 13.1 4.6313.9 5.7814.4 13.416.1 12.815.3 13 4.6813.7 5.5314.5 13.516.1 12.715.2 12.8 4.7613.6 5.3314.6 13.616.2 12.615.4 12.7 4.9413.6 5.1714.8 13.916.4 12.515.6 12.6 5.0313.6 5.0416.6 12.415.6 12.45.113.6 4.9312.2 13.516.7 12.3 12.3 5.0513.6 4.8411.9 13.516.8 12.215.6 12.1 4.8913.5 4.7311.7 13.616.9 12.115.7 12 4.8413.3 4.5811.6 13.616.9 11.915.5 11.8 4.8311.3 13.516.9 11.815.4 11.6 4.7613.3 4.5811.2 13.516.9 11.615.2 11.7 4.6613.1 4.3911.1 13.516.9 11.4 11.9 4.5812.9 4.2511 13.516.8 11.215.2 11.9 4.4812.8 4.1610.9 13.516.71115.3 11.7 4.3912.6 4.0910.8 13.616.61115.2 11.5 4.4112.5 4.0510.7 13.616.5 11.1 12.4 4.0110.6 13.516.31115.2 11.9 4.8712.2 3.9810.5 13.316.1 10.915.2 11.9 4.8712.13.910.4 13.215.9 10.8 12 3.7510.31315.8 10.615.3 11.9 4.8411.9 3.5610.2 12.915.6 10.515.4 11.8 5.0111.8 3.3710.2 12.715.5 10.4 11.7 5.1411.83.210 12.615.3 10.415.3 11.7 5.2611.7 3.079.9 12.415.2 10.415.3 11.7 5.3911.5 2.969.83 12.315 10.4 11.9 5.4511.4 2.859.74 12.214.8 10.415.4 12 5.5111.2 2.779.6 12.114.7 10.515.4 12.2 5.6211 2.859.38 12.114.5 10.4 12.3 5.7610.9 3.059.151214.3 10.315.7 12.4 5.9111 3.199.05 11.914.2 10.415.5 12.5 6.0811.2 3.388.921214 10.415.3 12.6 6.2311.3 3.578.79 12.113.8 10.3 12.7 6.3611.3 3.718.64 12.113.7 10.315.3 12.8 6.4611.2 3.848.49 12.213.5 10.215.2 11 3.918.32 12.113.4 10.2 13.2 6.2910.9 3.958.141213.2 10.115.2 13.2 6.6510.8 3.967.97 11.913.1 9.9815 13.2 6.7510.7 3.857.82 11.813 9.7214.9 13.3 6.8110.6 3.677.7 11.712.9 9.4714.8 13.1 6.9310.5 3.547.63 11.612.9 9.3614.7 13.2 6.9810.4 3.447.49 11.512.9 9.2614.6 13.4 6.9910.2 3.377.39 11.312.9 9.1114.5 13.7 6.9910.1 3.327.42 11.213 8.9914.4 9.92 3.327.581113.1 8.8614.2 13.4 7.649.79 3.377.6