中国地图(到市级-EXCEL版).xls

1、中国数据地图（到市级）生成模板地图绘制：郑薇 Vivi。免责声明：并不保证地市图形完全对应准确，商用请自行仔细核对无误。模型建立：ExcelPro的图表博客 http:/ExcelP2010.11.61、填入数据： 2、设置图例： 3、设置阀值：在D列填入/粘贴数值 G11:H15将被作为图例 输入分档的下限值数值： 填色：云南 德宏州 Dehong 95.09 color5 1 020 0红河州 Honghe 26.13 color2 2 2040 20临沧市 Lincang 37.80 color2 3 4060 40文山州 Wenshan 30.71 color2 4 6080 60昆明

2、市 Kunming 64.02 color4 5 80+ 80曲靖市 Qujing 26.48 color2 6 +玉溪市 Yuxi 36.06 color2 7昭通市 Shaotong 87.31 color5 8大理州 Dali 64.84 color4 9楚雄州 Chuxiong 61.71 color4 10普洱市 Puer 2.80 color1保山市 Baoshan 90.38 color5 以上预留了5个分档的位置，若需要可往下添加版纳州 Xishuangbanna70.70 color4迪庆州 DiqingYN 41.22 color3怒江州 Nujiang 63.86 col

3、or4丽江市 Lijiang 64.77 color4广西 南宁 Nanning 25.36 color2柳州 Liuzhou 55.95 color3 以下仅为备用百色 Baise 8.60 color1梧州 Wuzhou 47.91 color3钦州 Qinzhou 66.27 color4 最小值： 0.08来宾 Laibin 18.75 color1 最大值： 99.41崇左 Chongzuo 15.81 color1 所分档数： 5桂林 Guilin 70.05 color4 间隔参考： 19.86559贺州 Hezhou 62.47 color4河池 Hechi 50.20 col

4、or3北海 Beihai 54.47 color3防城港 Fangchenggang43.69 color3贵港 Guigang 74.57 color4玉林 Yulin 26.71 color2黑龙江 哈尔滨市 Haerbin 0.13 color1齐齐哈尔市Qiqihaer 3.55 color1牡丹江市 Mudanjiang 72.65 color4佳木斯市 Jiamusi 40.39 color3 ExcelPro的图表博客大庆市 Daqing 65.58 color4七台河市 Qitaihe 89.45 color5 搜狐博客：绥化市 Suihua 63.46 color4 新浪微博

5、：伊春市 YichunHLJ 67.32 color4 豆瓣读书：鸡西市 Jixi 29.03 color2 图表之道：黑河市 Heihe 51.19 color3 图表书架：鹤岗 Hegang 14.38 color1双鸭山 Shuangyashan92.88 color5大兴安岭地区Daxinganling 79.71 color4陕西 西安市 Xian 44.92 color3铜川市 Tongchuan 15.46 color1宝鸡市 Baoji 54.64 color3咸阳+杨凌市Xianyang 30.50 color2渭南市 Weinan 83.46 color5延安市 Yanan

6、 46.81 color3汉中市 Hanzhong 87.28 color5榆林市 YulinSX 18.87 color1安康市 Ankang 48.17 color3商洛市 Shangluo 18.35 color1辽宁 沈阳 Shenyang 13.83 color1大连 Dalian 77.72 color4鞍山 Anshan 32.65 color2抚顺 Fushun 19.52 color1本溪 Benxi 16.98 color1丹东 Dandong 28.33 color2锦州 Jinzhou 7.99 color1营口 Yingkou 19.61 color1阜新 Fuxin

7、 78.70 color4辽阳 Liaoyang 55.01 color3铁岭 Tieling 54.67 color3朝阳 Chaoyang 74.18 color4盘锦 Panjin 54.13 color3葫芦岛 Huludao 82.95 color5贵阳市 Guiyang 77.84 color4遵义市 Zunyi 57.00 color3安顺市 Anshun 37.94 color2黔南州 Qiannan 95.06 color5黔东南州 Qiandongnan 15.53 color1铜仁地区 Tongren 48.51 color3毕节地区 Bijie 47.35 color3

8、六盘水市 Liupanshui 2.97 color1黔西南州 Qianxinan 37.86 color2西藏 拉萨市 Lasa 44.33 color3日喀则 Rikeze 52.00 color3昌都 Changdu 44.02 color3林芝 Linzhi 49.17 color3山南 Shannan 75.28 color4阿里 Ali 44.61 color3那曲 Naqu 63.81 color4福建 福州 Fuzhou 23.21 color2厦门 Xiamen 8.76 color1泉州 Quanzhou 4.64 color1漳州 Zhangzhou 87.10 colo

9、r5莆田 Putian 31.14 color2三明 Sanming 53.91 color3宁德 Ningde 72.15 color4龙岩 Longyan 54.24 color3南平 Nanping 87.32 color5湖北 武汉市 Wuhan 39.36 color2黄石市 Huangshi 61.15 color4十堰市 Shiyan 12.27 color1宜昌 Yichang 3.13 color1襄樊市 Xiangfan 0.46 color1鄂州 Ezhou 89.07 color5荆门市 Jingmen 66.61 color4孝感市 Xiaogan 59.20 col

10、or3荆州市 Jingzhou 80.73 color5黄冈市 Huanggang 75.17 color4咸宁市 Xianning 64.03 color4随州 Suizhou 59.07 color3恩施州 Enshi 70.67 color4神农架林区Shennongjia 38.95 color2天门市 Tianmen 12.79 color1潜江 Qianjiang 63.08 color4仙桃市 Xiantao 39.23 color2海南 海口市 Haikou 58.01 color3三亚市 Sanya 64.60 color4海南其它 HainanQT 94.07 color5

11、浙江 杭州市 Hangzhou 48.48 color3宁波市 Ningbo 66.73 color4温州市 Wenzhou 92.62 color5嘉兴市 Jiaxing 47.75 color3湖州市 Huzhou 87.82 color5绍兴市 Shaoxing 75.33 color4金华市 Jinhua 87.71 color5衢州市 Quzhou 54.57 color3舟山市 Zhoushan 69.17 color4台州市 Taizhou 18.61 color1丽水市 Lishui 0.08 color1江西 南昌市 Nanchang 74.35 color4萍乡市 Ping

12、xiang 85.73 color5新余市 Xinyu 25.54 color2九江市 Jiujiang 80.16 color5抚州市 FuzhouJX 18.32 color1赣州市 Ganzhou 89.99 color5景德镇市 Jingdezhen 33.26 color2吉安市 Jian 17.54 color1上饶市 Shangrao 59.95 color3宜春市 Yichun 14.70 color1鹰潭市 Yingtan 72.34 color4新疆 乌鲁木齐市Urumqi 27.62 color2克拉玛依市Karamay 31.36 color2哈密地区 Hami 21.

13、01 color2吐鲁番地区Turpan 71.44 color4博州 Boertala 36.42 color2阿勒泰地区Aletai 1.57 color1塔城地区 Tacheng 52.85 color3昌吉州 Changji 99.41 color5伊犁州直 Yili 3.83 color1巴州 Bayinguole 58.79 color3阿克苏地区Akesu 6.59 color1克州 Kezilesu 57.18 color3喀什地区 Kashgar 96.21 color5和田地区 Hotan 81.32 color5吉林 长春 Changchun 56.52 color3吉林

14、 Jilin 77.89 color4通化 Tonghua 96.03 color5四平 Siping 74.93 color4白城 Baicheng 35.26 color2白山 Baishan 3.42 color1松源 Songyuan 98.10 color5辽源 Liaoyuan 42.56 color3延边 Yanbian 98.24 color5安徽 合肥市 Hefei 92.59 color5芜湖市 Wuhu 82.72 color5蚌埠市 Bengbu 95.65 color5淮南市 Huainan 76.12 color4马鞍山市 Maanshan 38.66 color2

15、淮北市 Huaibei 87.65 color5铜陵市 Tongling 79.69 color4安庆市 Anqing 16.15 color1黄山市 Huangshan 78.39 color4滁州市 Chuzhou 58.06 color3阜阳市 Fuyang 65.08 color4亳州市 bozhou 14.59 color1宿州市 SuzhouAH 72.93 color4六安市 Liuan 16.63 color1宣城市 Xuancheng 18.32 color1巢湖市 Chaohu 54.23 color3池州市 Chizhou 10.78 color1银川市 Yinchuan

16、 6.35 color1石嘴山市 Shizuishan 91.28 color5吴忠市 Wuzhong 60.09 color4固原市 Guyuan 58.22 color3中卫市 Zhongwei 45.58 color3凉山 Liangshan 1.15 color1四川 成都 Chengdu 97.13 color5自贡 Zigong 50.07 color3攀枝花 Panzhihua 4.37 color1泸州 Luzhou 18.01 color1德阳 Deyang 37.69 color2绵阳 Mianyang 30.38 color2广元 Guangyuan 47.56 colo

17、r3遂宁 Suining 79.44 color4内江 Neijiang 90.97 color5乐山 Leshan 0.44 color1南充 Nanchong 54.51 color3宜宾 Yibin 24.75 color2广安 Guangan 38.77 color2雅安 Yaan 16.96 color1阿坝州 Aba 64.86 color4甘孜州 Ganzi 73.60 color4巴中 Bazhong 72.24 color4眉山 Meishan 24.88 color2资阳 Ziyang 74.50 color4达州 Dazhou 67.95 color4北京 Beijing

18、 57.31 color3内蒙古 呼和浩特市huhehaote 8.75 color1包头市 Baotou 83.66 color5乌海市 Wuhai 68.90 color4赤峰市 Chifeng 18.97 color1通辽市 Tongliao 80.03 color5鄂尔多斯市Eerduosi 27.62 color2呼伦贝尔市Hulunbier 58.28 color3乌兰察布市Wulanchabu 66.52 color4巴彦淖尔市Bayanzhuoer 35.36 color2兴安盟 Xingan 41.31 color3锡林郭勒盟Xilinguole 95.74 color5阿拉

19、善盟 Alashan 66.07 color4河北 廊坊 Langfang 74.55 color4邢台市 Xingtai 60.16 color4石家庄 Shijiazhuang 39.60 color2保定市 Baoding 11.25 color1邯郸市 Handan 67.85 color4唐山市 Tangshan 43.74 color3承德市 Chengde 20.63 color2沧州市 Cangzhou 66.58 color4张家口市 Zhangjiakou 9.91 color1秦皇岛市 Qinhuangdao 72.92 color4衡水市 Hengshui 44.00

20、color3重庆 Chongqing 34.30 color2上海 Shanghai 99.16 color5宁夏 西宁市 Xining 87.70 color5海东地区 Haidong 74.85 color4海北州 Haibei 86.54 color5黄南州 Huangnan 10.24 color1海南州 Hainan 68.05 color4果洛州 Guoluo 76.66 color4玉树州 Yushu 60.84 color4海西州 Haixi 41.27 color3湖南 长沙市 Changsha 87.49 color5株洲市 Zhuzhou 83.25 color5湘潭市

21、Xiangtan 8.69 color1衡阳市 Hengyang 92.49 color5邵阳市 Shaoyang 29.64 color2岳阳市 Yueyang 97.87 color5常德市 Changde 77.89 color4张家界市 Zhangjiajie 31.81 color2益阳市 Yiyang 8.60 color1郴州市 Chenzhou 92.18 color5永州市 Yongzhou 14.12 color1怀化市 Huaihua 55.54 color3娄底市 Loudi 79.93 color4湘西自治州xiangxi 41.26 color3河南 郑州市 Zhe

22、ngzhou 42.23 color3开封市 Kaifeng 29.37 color2洛阳市 Luoyang 95.34 color5平顶山市 Pingdingshan 31.33 color2安阳市 Anyang 78.73 color4鹤壁市 Hebi 84.62 color5新乡市 Xinxiang 64.05 color4焦作市 Jiaozuo 2.30 color1濮阳市 Puyang 63.67 color4许昌市 Xuchang 85.46 color5漯河市 Luohe 78.42 color4三门峡 Sanmenxia 81.64 color5南阳市 Nanyang 52.5

23、9 color3商丘市 Shangqiu 25.57 color2信阳市 Xinyang 35.00 color2周口市 Zhoukou 11.14 color1驻马店市 Zhumadian 4.65 color1济源市 Jiyuan 33.99 color2讲师 南京 Nanjing 93.79 color5无锡 Wuxi 0.71 color1徐州 Xuzhou 1.43 color1常州 Changzhou 86.24 color5苏州 Suzhou 82.37 color5南通 Nantong 77.20 color4连云港 Lianyungang 52.44 color3淮安 Hua

24、ian 98.52 color5盐城 Yancheng 68.19 color4扬州 Yangzhou 34.39 color2镇江 Zhenjiang 49.24 color3泰州 TaizhouJS 47.74 color3宿迁 Suqian 57.90 color3天津 Tianjin 32.95 color2广东 广州 Guangzhou 65.67 color4深圳 Shenzhen 36.78 color2韶关 Shaoguan 27.59 color2珠海 Zhuhai 82.25 color5汕头 Shantou 70.10 color4佛山 Fuoshan 81.24 col

25、or5江门 Jiangmen 90.15 color5湛江 Zhanjiang 4.47 color1茂名 Maoming 37.53 color2肇庆 Zhaoqing 93.92 color5惠州 Huizhou 25.58 color2梅州 Meizhou 35.65 color2汕尾 Shanwei 80.90 color5河源 Heyuan 69.03 color4阳江 Yangjiang 53.62 color3清远 Qingyuan 47.39 color3东莞 Dongwan 7.87 color1中山 Zhongshan 24.91 color2潮州 Chaozhou 23.

26、82 color2揭阳 Jieyang 73.95 color4云浮 Yunfu 25.81 color2山东 济南市 Jinan 96.59 color5青岛市 Qingdao 4.58 color1淄博市 Zibo 36.49 color2枣庄市 Zaozhuang 3.74 color1东营市 Dongying 50.35 color3烟台市 Yantai 49.82 color3潍坊市 Weifang 84.34 color5威海市 Weihai 39.08 color2泰安市 Taian 69.88 color4莱芜市 Laiwu 42.22 color3济宁市 Jining 62.

27、37 color4临沂市 Linyi 83.55 color5日照市 Rizhao 9.78 color1德州市 Dezhou 82.40 color5聊城市 Liaocheng 45.12 color3滨州市 Binzhou 9.98 color1菏泽市 Heze 47.93 color3山西 临汾市 Linfen 63.45 color4晋中市 Jinzhong 76.99 color4阳泉市 Yangquan 42.50 color3大同市 Datong 36.72 color2运城市 Yuncheng 1.21 color1晋城市 Jincheng 30.74 color2朔州市 Sh

28、uozhou 5.59 color1吕梁市 Lvliang 79.60 color4长治市 Changzhi 13.20 color1忻州市 Xinzhou 68.46 color4太原市 Taiyuan 58.96 color3甘肃 兰州市 lanzhou 80.86 color5嘉峪关市 Jiayuguan 15.88 color1金昌市 Jinchang 51.00 color3白银市 Baiyin 61.70 color4天水市 Tianshui 64.54 color4武威市 Wuwei 77.68 color4张掖市 Zhangye 48.55 color3平凉市 Pinglian

29、g 72.76 color4酒泉市 Jiuquan 6.32 color1庆阳市 Qingyang 41.31 color3定西市 Dingxi 45.38 color3陇南市 longnan 86.72 color5临夏州 Linxia 61.50 color4甘南州 Gannan 47.73 color34、生成地图 5、OK，复制走吧！color1color2color3color4color5http:/ExcelPhttp:/ 色B e n g b uP u e r H o n g h eW e n s h a nX is h a n g b a n n aY u x iL in c

30、 a n gS h a o to n gD a liC h u x io n gD e h o n gB a o s h a nD iq in gN u jia n gL ijia n gK u n m in gQ u jin gB a is eL iu z h o uN a n n in gG u ig a n gW u z h o uQ in z h o uL a ib inC h o n g z u oG u ilinH e z h o uH e c h iB e ih a iF a n g c h e n g g a n gY u linH a e rb inQ iq ih a e r

31、M u d a n jia n gJ ia m u s iD a q in gQ ita ih eS u ih u aY ic h u nJ ix iH e ih eF u y a n gHuainanliu a nH e fe iy a n g zh o uH e g a n gS h u a n g y a s h a nD a x in g a n lin gX ia nT o n g c h u a nB a o jiW e in a nY a n a nH a n z h o n gY u linA n k a n gS h a n g lu oX ia n y a n gS h e

32、 n y a n gD a lia nA n s h a nF u s h u nB e n x iD a n d o n gJ in z h o uY in g k o uF u x inL ia o y a n gT ie lin gC h a o y a n g P a n jinH u lu d a oG u iy a n gZ u n y iA n s h u nQ ia n n a nQ ia n d o n g n a nT o n g re nB ijieL iu p a n s h u iQ ia n x in a nL a s aR ik e z eC h a n g d

33、uL in z h iS h a n n a nN a q uA liF u z h o uX ia m e nQ u a n z h o uZ h a n g z h o uP u tia nS a n m in gN in g d eL o n g y a nN a n p in gW u h a nH u a n g s h iS h iy a nY ic h a n gX ia n g fa ne z h o uJ in g m e n X ia o g a nJ in g z h o uH u a n g g a n gX ia n n in gS u iz h o uE n s h

34、 iS h e n n o n g jiaT ia n m e nQ ia n jia n gX ia n ta oH a ik o uS a n y aH a in a nH a n g z h o u N in g b oW e n z h o uJ ia x in gH u z h o uS h a o x in gJ in h u aQ u z h o uZ h o u s h a nT a iz h o uL is h u iN a n c h a n gP in g x ia n gJ ia nX in y uJ iu jia n gG a n z h o uJ in g d e

35、z h e nS h a n g ra oY in g ta nY ic h u nF u z h o uU ru m q iK a ra m a yH a m iT u rp a nB o e rta laA le ta iT a c h e n gC h a n g jiY iliB a y in g u o leA k e s uK e z ile s uK a s h g a rH o ta nC h a n g c h u nJ ilinT o n g h u aS ip in gB a ic h e n gB a is h a nS o n g y u a nL ia o y u

36、a nY a n b ia nW u h uM a a n s h a nH u a ib e iT o n g lin gA n q in gH u a n g s h a nC h u z h o uB o z h o uS u z h o uX u a n c h e n gC h a o h uC h iz h o uY in c h u a nS h iz u is h a nW u z h o n gG u y u a nZ h o n g w e iW u d uZ ig o n gP a n z h ih u aL u z h o uD e y a n gM ia n y a

37、n gG u a n g y u a nS u in in gN e ijia n gL e s h a nY ib inN a n c h o n gG u a n g a nY a a nA b aG a n z iB a z h o n gM e is h a n Z iy a n gD a z h o uC h e n g d uL ia n g s h a nH u h e h a o teB a o to uW u h a iC h ife n gT o n g lia oE e rd u o s iH u lu n b ie rW u la n c h a b uB a y a

38、n z h u o e rX in g a nX ilin g u o leA la s h a nL a n g fa n gB e ijin gT ia n jinX in g ta iS h ijia z h u a n gB a o d in gH a n d a nT a n g s h a nC h e n g d eC a n g z h o uZ h a n g jia k o uQ in h u a n g d a oH e n g s h u iS h a n g h a iC h o n g q in gX in in gH a id o n gH a ib e iH u

39、 a n g n a nH a in a nG u o lu oH a ix iY u s h uC h a n g s h aZ h u z h o uX ia n g ta nH e n g y a n gS h a o y a n gY u e y a n gC h a n g d eZ h a n g jia jieY iy a n gC h e n z h o uY o n g z h o uH u a ih u aX ia n g s iL o u d iZ h e n g z h o uK a ife n gL u o y a n gP in g d in g s h a nA

40、n y a n gH e b iX in x ia n gJ ia o z u oP u y a n gX u c h a n gL u o h eS a n m e n x iaN a n y a n gS h a n g q iuX in y a n gZ h o u k o uZ h u m a d ia nJ iy u a nN a n jin gW u x iX u z h o uC h a n g z h o uS u z h o uN a n to n gL ia n y u n g a n gH u a ia nS u q ia nY a n c h e n gZ h e n

41、jia n gT a iz h o uG u a n g z h o uS h e n z h e nS h a o g u a nZ h u h a iA o m e nX ia n g g a n gS h a n to uF u o s h a nJ ia n g m e nZ h a n jia n gM a o m in gZ h a o q in gH u iz h o uM e iz h o uS h a n w e iH e y u a nY a n g jia n gQ in g y u a nD o n g w a nz h o n g s h a nJ ie y a n

42、gC h a o z h o uY u n fuJ in a nQ in g d a oZ ib oZ a o z h u a n gD o n g y in g Y a n ta i W e ih a iT a ia nW e ifa n gL a iw uJ in in gL in y iR iz h a oD e z h o uH e z eB in z h o uL ia o c h e n gL in fe nJ in z h o n gY a n g q u a nD a to n gY u n c h e n gJ in c h e n gS h u o z h o uL v l

43、ia n gC h a n g z h iX in z h o uT a iy u a nJ iu q u a nT a iw a n0 2 02 0 4 04 0 6 06 0 8 08 0 +P o w e r d b y E x c e lP r o的 图 表 博 客地图绘制：郑薇 Vivi。免责声明：并不保证地市图形完全对应准确，商用请自行仔细核对无误。3、设置阀值：输入分档的下限值以上预留了5个分档的位置，若需要可往下添加ExcelPro的图表博客B e n g b uP u e r H o n g h eW e n s h a nX is h a n g b a n n aY u

44、x iL in c a n gS h a o to n gD a liC h u x io n gD e h o n gB a o s h a nD iq in gN u jia n gL ijia n gK u n m in gQ u jin gB a is eL iu z h o uN a n n in gG u ig a n gW u z h o uQ in z h o uL a ib inC h o n g z u oG u ilinH e z h o uH e c h iB e ih a iF a n g c h e n g g a n gY u linH a e rb inQ iq

45、 ih a e rM u d a n jia n gJ ia m u s iD a q in gQ ita ih eS u ih u aY ic h u nJ ix iH e ih eF u y a n gHuainanliu a nH e fe iy a n g zh o uH e g a n gS h u a n g y a s h a nD a x in g a n lin gX ia nT o n g c h u a nB a o jiW e in a nY a n a nH a n z h o n gY u linA n k a n gS h a n g lu oX ia n y a

46、 n gS h e n y a n gD a lia nA n s h a nF u s h u nB e n x iD a n d o n gJ in z h o uY in g k o uF u x inL ia o y a n gT ie lin gC h a o y a n g P a n jinH u lu d a oG u iy a n gZ u n y iA n s h u nQ ia n n a nQ ia n d o n g n a nT o n g re nB ijieL iu p a n s h u iQ ia n x in a nL a s aR ik e z eC h

47、 a n g d uL in z h iS h a n n a nN a q uA liF u z h o uX ia m e nQ u a n z h o uZ h a n g z h o uP u tia nS a n m in gN in g d eL o n g y a nN a n p in gW u h a nH u a n g s h iS h iy a nY ic h a n gX ia n g fa ne z h o uJ in g m e n X ia o g a nJ in g z h o uH u a n g g a n gX ia n n in gS u iz h o

48、 uE n s h iS h e n n o n g jiaT ia n m e nQ ia n jia n gX ia n ta oH a ik o uS a n y aH a in a nH a n g z h o u N in g b oW e n z h o uJ ia x in gH u z h o uS h a o x in gJ in h u aQ u z h o uZ h o u s h a nT a iz h o uL is h u iN a n c h a n gP in g x ia n gJ ia nX in y uJ iu jia n gG a n z h o uJ

49、in g d e z h e nS h a n g ra oY in g ta nY ic h u nF u z h o uU ru m q iK a ra m a yH a m iT u rp a nB o e rta laA le ta iT a c h e n gC h a n g jiY iliB a y in g u o leA k e s uK e z ile s uK a s h g a rH o ta nC h a n g c h u nJ ilinT o n g h u aS ip in gB a ic h e n gB a is h a nS o n g y u a nL ia o y u a nY a n b ia nW u h uM a a n s h a nH u a ib e iT o n g lin gA n q in gH u a n g s h a nC