中国数据地图-到市级-分档填色.xls

1、中国数据地图（到市级）生成模板地图绘制：郑薇 Vivi。免责声明：并不保证地市图形完全对应准确，商用请自行仔细核对无误。模型建立：ExcelPro的图表博客http:/ExcelP2010.11.61、填入数据：2、设置图例：3、设置阀值：在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值：填色：云南德宏州Dehong47.01 color310200红河州Honghe87.13 color52204020临沧市Lincang35.26 color23406040文山州Wenshan15.24 color14608060昆明市Kunming97.75 color5580+80曲

2、靖市Qujing8.49 color16+玉溪市Yuxi74.74 color47昭通市Shaotong68.76 color48大理州Dali4.17 color19楚雄州Chuxiong54.56 color310普洱市Puer72.05 color4保山市Baoshan97.81 color5以上预留了5个分档的位置，若需要可往下添加版纳州Xishuangbanna10.10 color1迪庆州DiqingYN43.00 color3怒江州Nujiang34.08 color2丽江市Lijiang15.49 color1广西南宁Nanning59.87 color3柳州Liuzhou17

3、.31 color1以下仅为备用百色Baise91.87 color5梧州Wuzhou52.52 color3钦州Qinzhou20.70 color2最小值：0.40来宾Laibin60.75 color4最大值：99.97崇左Chongzuo13.19 color1所分档数：5桂林Guilin51.82 color3间隔参考：19.91583贺州Hezhou7.57 color1河池Hechi30.99 color2北海Beihai86.98 color5防城港Fangchenggang33.24 color2贵港Guigang39.26 color2玉林Yulin0.64 color1黑

4、龙江哈尔滨市Haerbin68.14 color4齐齐哈尔市Qiqihaer19.45 color1牡丹江市Mudanjiang94.10 color5佳木斯市 Jiamusi72.59 color4ExcelPro的的图图表表博博客客大庆市Daqing78.26 color4七台河市Qitaihe60.95 color4搜狐博客：绥化市Suihua45.34 color3新浪微博：伊春市YichunHLJ39.77 color2豆瓣读书：鸡西市Jixi14.81 color1图表之道：黑河市Heihe1.01 color1图表书架：鹤岗Hegang20.23 color2双鸭山Shuangy

5、ashan 52.31 color3大兴安岭地区Daxinganling75.97 color4陕西西安市Xian26.93 color2铜川市Tongchuan24.79 color2宝鸡市Baoji85.20 color5咸阳+杨凌市 Xianyang44.09 color3渭南市Weinan53.31 color3延安市Yanan0.40 color1汉中市Hanzhong51.05 color3榆林市YulinSX26.48 color2安康市Ankang94.24 color5商洛市Shangluo78.22 color4辽宁沈阳Shenyang47.36 color3大连Dalia

6、n72.40 color4鞍山Anshan44.42 color3抚顺Fushun61.87 color4本溪Benxi94.47 color5丹东Dandong73.87 color4锦州Jinzhou76.24 color4营口Yingkou6.28 color1阜新Fuxin40.59 color3辽阳Liaoyang49.96 color3铁岭Tieling86.39 color5朝阳Chaoyang18.61 color1盘锦Panjin66.58 color4葫芦岛Huludao24.09 color2贵阳市Guiyang92.90 color5遵义市Zunyi77.13 colo

7、r4安顺市Anshun93.03 color5黔南州Qiannan30.34 color2黔东南州Qiandongnan71.83 color4铜仁地区Tongren75.03 color4毕节地区Bijie84.69 color5六盘水市Liupanshui7.18 color1黔西南州Qianxinan37.43 color2西藏拉萨市Lasa62.46 color4日喀则Rikeze91.86 color5昌都Changdu51.45 color3林芝Linzhi7.83 color1山南Shannan49.03 color3阿里Ali59.65 color3那曲Naqu94.65 co

8、lor5福建福州Fuzhou75.45 color4厦门Xiamen64.32 color4泉州Quanzhou75.53 color4漳州Zhangzhou94.85 color5莆田Putian50.32 color3三明Sanming3.40 color1宁德Ningde94.68 color5龙岩Longyan58.11 color3南平Nanping64.05 color4湖北武汉市Wuhan9.94 color1黄石市Huangshi78.59 color4十堰市Shiyan4.66 color1宜昌Yichang25.03 color2襄樊市Xiangfan68.37 color

9、4鄂州Ezhou61.90 color4荆门市Jingmen95.54 color5孝感市Xiaogan31.64 color2荆州市Jingzhou81.66 color5黄冈市Huanggang74.62 color4咸宁市Xianning71.59 color4随州Suizhou82.10 color5恩施州Enshi23.82 color2神农架林区Shennongjia24.83 color2天门市Tianmen78.71 color4潜江Qianjiang16.06 color1仙桃市Xiantao49.94 color3海南海口市Haikou99.97 color5三亚市Sany

10、a13.11 color1海南其它HainanQT47.32 color3浙江杭州市Hangzhou34.80 color2宁波市Ningbo92.93 color5温州市Wenzhou55.56 color3嘉兴市Jiaxing55.62 color3湖州市Huzhou39.95 color2绍兴市Shaoxing42.94 color3金华市Jinhua72.70 color4衢州市Quzhou64.78 color4舟山市Zhoushan31.33 color2台州市Taizhou22.91 color2丽水市Lishui53.24 color3江西南昌市Nanchang82.03 co

11、lor5萍乡市Pingxiang51.42 color3新余市Xinyu43.08 color3九江市Jiujiang62.79 color4抚州市FuzhouJX97.61 color5赣州市Ganzhou0.56 color1景德镇市Jingdezhen31.91 color2吉安市Jian52.18 color3上饶市Shangrao39.12 color2宜春市Yichun88.61 color5鹰潭市Yingtan0.51 color1新疆乌鲁木齐市Urumqi40.28 color3克拉玛依市Karamay92.89 color5哈密地区Hami20.34 color2吐鲁番地区T

12、urpan14.61 color1博州Boertala47.26 color3阿勒泰地区Aletai80.53 color5塔城地区Tacheng26.77 color2昌吉州Changji88.70 color5伊犁州直Yili68.17 color4巴州Bayinguole72.33 color4阿克苏地区Akesu8.88 color1克州Kezilesu60.07 color4喀什地区Kashgar57.68 color3和田地区Hotan90.12 color5吉林长春Changchun5.00 color1吉林Jilin32.87 color2通化Tonghua15.06 colo

13、r1四平Siping67.12 color4白城Baicheng44.98 color3白山Baishan65.80 color4松源Songyuan87.10 color5辽源Liaoyuan18.99 color1延边Yanbian13.55 color1安徽合肥市Hefei6.00 color1芜湖市Wuhu74.28 color4蚌埠市Bengbu69.48 color4淮南市Huainan38.86 color2马鞍山市Maanshan4.07 color1淮北市Huaibei82.84 color5铜陵市Tongling29.37 color2安庆市Anqing52.86 colo

14、r3黄山市Huangshan38.17 color2滁州市Chuzhou11.10 color1阜阳市Fuyang0.82 color1亳州市bozhou43.66 color3宿州市SuzhouAH12.49 color1六安市Liuan59.87 color3宣城市Xuancheng8.09 color1巢湖市Chaohu8.86 color1池州市Chizhou10.86 color1银川市Yinchuan90.47 color5石嘴山市Shizuishan74.18 color4吴忠市Wuzhong35.75 color2固原市Guyuan32.70 color2中卫市Zhongwei

15、37.41 color2凉山Liangshan18.30 color1四川成都Chengdu68.27 color4自贡Zigong26.21 color2攀枝花Panzhihua53.04 color3泸州Luzhou23.78 color2德阳Deyang39.73 color2绵阳Mianyang58.11 color3广元Guangyuan60.44 color4遂宁Suining1.90 color1内江Neijiang78.95 color4乐山Leshan47.46 color3南充Nanchong91.73 color5宜宾Yibin7.94 color1广安Guangan37

16、.54 color2雅安Yaan24.56 color2阿坝州Aba38.75 color2甘孜州Ganzi79.94 color4巴中Bazhong5.15 color1眉山Meishan17.29 color1资阳Ziyang78.10 color4达州Dazhou13.96 color1北京Beijing90.76 color5内蒙古呼和浩特市huhehaote97.49 color5包头市Baotou63.34 color4乌海市Wuhai18.83 color1赤峰市Chifeng46.08 color3通辽市Tongliao2.89 color1鄂尔多斯市Eerduosi53.48 color3呼伦贝尔市Hulunbier43.74 color3乌兰察布市Wulanchabu11.04 color1巴彦淖尔市Bayanzhuoer39.24 color2兴安盟Xingan30.06 color2锡林郭勒盟Xilinguole8.68 color1阿拉善盟Alashan36.06 color2河北廊坊 Langfang44.81 color3邢台市Xingtai26.42 c