1、中国数据地图(到市级)生成模板地图绘制:郑薇 Vivi。免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。模型建立:ExcelPro的图表博客http:/ExcelP2010.11.61、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong40.45 color310200红河州Honghe43.24 color32204020临沧市Lincang49.83 color33406040文山州Wenshan94.83 color54608060昆明市Kunming73.87 color4580+80曲
2、靖市Qujing25.73 color26+玉溪市Yuxi64.03 color47昭通市Shaotong69.05 color48大理州Dali51.26 color39楚雄州Chuxiong35.50 color210普洱市Puer22.92 color2保山市Baoshan17.77 color1以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna89.92 color5迪庆州DiqingYN29.58 color2怒江州Nujiang47.49 color3丽江市Lijiang28.52 color2广西南宁Nanning0.68 color1柳州Liuzhou9
3、7.05 color5以下仅为备用百色Baise95.46 color5梧州Wuzhou55.39 color3钦州Qinzhou0.23 color1最小值:0.21来宾Laibin68.59 color4最大值:99.98崇左Chongzuo35.81 color2所分档数:5桂林Guilin55.52 color3间隔参考:19.95557贺州Hezhou91.06 color5河池Hechi68.05 color4北海Beihai80.57 color5防城港Fangchenggang41.74 color3贵港Guigang74.48 color4玉林Yulin34.90 color
4、2黑龙江哈尔滨市Haerbin86.61 color5齐齐哈尔市Qiqihaer68.29 color4牡丹江市Mudanjiang50.13 color3佳木斯市 Jiamusi86.05 color5ExcelPro的的图图表表博博客客大庆市Daqing52.70 color3七台河市Qitaihe44.83 color3搜狐博客:绥化市Suihua62.59 color4新浪微博:伊春市YichunHLJ13.60 color1豆瓣读书:鸡西市Jixi46.15 color3图表之道:黑河市Heihe77.36 color4图表书架:鹤岗Hegang76.67 color4双鸭山Shua
5、ngyashan 35.33 color2大兴安岭地区Daxinganling26.23 color2陕西西安市Xian19.09 color1铜川市Tongchuan30.11 color2宝鸡市Baoji72.86 color4咸阳+杨凌市 Xianyang39.83 color2渭南市Weinan81.08 color5延安市Yanan60.32 color4汉中市Hanzhong60.30 color4榆林市YulinSX10.84 color1安康市Ankang45.83 color3商洛市Shangluo20.69 color2辽宁沈阳Shenyang18.49 color1大连D
6、alian94.25 color5鞍山Anshan51.18 color3抚顺Fushun29.03 color2本溪Benxi16.36 color1丹东Dandong62.17 color4锦州Jinzhou72.41 color4营口Yingkou10.90 color1阜新Fuxin4.51 color1辽阳Liaoyang69.87 color4铁岭Tieling29.32 color2朝阳Chaoyang46.10 color3盘锦Panjin66.34 color4葫芦岛Huludao20.13 color2贵阳市Guiyang75.30 color4遵义市Zunyi53.24
7、color3安顺市Anshun20.64 color2黔南州Qiannan20.82 color2黔东南州Qiandongnan1.58 color1铜仁地区Tongren93.02 color5毕节地区Bijie7.27 color1六盘水市Liupanshui30.27 color2黔西南州Qianxinan9.06 color1西藏拉萨市Lasa84.43 color5日喀则Rikeze90.87 color5昌都Changdu59.88 color3林芝Linzhi17.59 color1山南Shannan1.84 color1阿里Ali5.11 color1那曲Naqu55.70 c
8、olor3福建福州Fuzhou13.78 color1厦门Xiamen49.05 color3泉州Quanzhou40.86 color3漳州Zhangzhou57.69 color3莆田Putian79.73 color4三明Sanming83.91 color5宁德Ningde74.11 color4龙岩Longyan17.78 color1南平Nanping71.93 color4湖北武汉市Wuhan65.51 color4黄石市Huangshi99.56 color5十堰市Shiyan35.13 color2宜昌Yichang16.89 color1襄樊市Xiangfan10.83 c
9、olor1鄂州Ezhou80.54 color5荆门市Jingmen17.99 color1孝感市Xiaogan14.96 color1荆州市Jingzhou41.93 color3黄冈市Huanggang97.82 color5咸宁市Xianning84.27 color5随州Suizhou56.86 color3恩施州Enshi96.41 color5神农架林区Shennongjia2.18 color1天门市Tianmen32.23 color2潜江Qianjiang81.07 color5仙桃市Xiantao72.76 color4海南海口市Haikou50.27 color3三亚市S
10、anya95.71 color5海南其它HainanQT60.69 color4浙江杭州市Hangzhou80.77 color5宁波市Ningbo61.08 color4温州市Wenzhou52.11 color3嘉兴市Jiaxing45.21 color3湖州市Huzhou23.63 color2绍兴市Shaoxing2.46 color1金华市Jinhua77.85 color4衢州市Quzhou48.13 color3舟山市Zhoushan35.71 color2台州市Taizhou85.66 color5丽水市Lishui32.94 color2江西南昌市Nanchang12.65
11、color1萍乡市Pingxiang52.51 color3新余市Xinyu43.75 color3九江市Jiujiang0.21 color1抚州市FuzhouJX20.58 color2赣州市Ganzhou90.48 color5景德镇市Jingdezhen92.04 color5吉安市Jian41.98 color3上饶市Shangrao58.82 color3宜春市Yichun64.49 color4鹰潭市Yingtan11.07 color1新疆乌鲁木齐市Urumqi71.42 color4克拉玛依市Karamay55.28 color3哈密地区Hami25.40 color2吐鲁番
12、地区Turpan33.09 color2博州Boertala9.02 color1阿勒泰地区Aletai61.14 color4塔城地区Tacheng71.48 color4昌吉州Changji57.73 color3伊犁州直Yili41.81 color3巴州Bayinguole76.65 color4阿克苏地区Akesu57.17 color3克州Kezilesu90.30 color5喀什地区Kashgar69.72 color4和田地区Hotan28.40 color2吉林长春Changchun51.24 color3吉林Jilin75.15 color4通化Tonghua38.69
13、color2四平Siping20.11 color2白城Baicheng84.37 color5白山Baishan49.02 color3松源Songyuan34.11 color2辽源Liaoyuan60.31 color4延边Yanbian52.00 color3安徽合肥市Hefei39.72 color2芜湖市Wuhu98.06 color5蚌埠市Bengbu24.82 color2淮南市Huainan22.47 color2马鞍山市Maanshan96.03 color5淮北市Huaibei29.16 color2铜陵市Tongling85.47 color5安庆市Anqing1.00
14、 color1黄山市Huangshan38.68 color2滁州市Chuzhou11.79 color1阜阳市Fuyang76.40 color4亳州市bozhou75.32 color4宿州市SuzhouAH2.59 color1六安市Liuan90.20 color5宣城市Xuancheng66.41 color4巢湖市Chaohu28.25 color2池州市Chizhou7.26 color1银川市Yinchuan13.57 color1石嘴山市Shizuishan7.29 color1吴忠市Wuzhong49.16 color3固原市Guyuan28.79 color2中卫市Zho
15、ngwei0.74 color1凉山Liangshan99.98 color5四川成都Chengdu87.19 color5自贡Zigong29.58 color2攀枝花Panzhihua8.48 color1泸州Luzhou5.20 color1德阳Deyang64.56 color4绵阳Mianyang67.88 color4广元Guangyuan29.87 color2遂宁Suining27.90 color2内江Neijiang38.28 color2乐山Leshan88.05 color5南充Nanchong0.87 color1宜宾Yibin3.79 color1广安Guangan
16、21.40 color2雅安Yaan27.90 color2阿坝州Aba72.77 color4甘孜州Ganzi96.46 color5巴中Bazhong22.45 color2眉山Meishan20.31 color2资阳Ziyang75.66 color4达州Dazhou71.50 color4北京Beijing46.74 color3内蒙古呼和浩特市huhehaote21.14 color2包头市Baotou2.83 color1乌海市Wuhai64.47 color4赤峰市Chifeng13.57 color1通辽市Tongliao54.15 color3鄂尔多斯市Eerduosi57
17、.60 color3呼伦贝尔市Hulunbier66.87 color4乌兰察布市Wulanchabu14.60 color1巴彦淖尔市Bayanzhuoer35.24 color2兴安盟Xingan79.09 color4锡林郭勒盟Xilinguole21.30 color2阿拉善盟Alashan13.66 color1河北廊坊 Langfang30.66 color2邢台市Xingtai51.23 color3石家庄Shijiazhuang62.99 color4保定市Baoding58.36 color3邯郸市 Handan60.49 color4唐山市 Tangshan86.69 co
18、lor5承德市Chengde45.22 color3沧州市Cangzhou42.84 color3张家口市Zhangjiakou76.00 color4秦皇岛市Qinhuangdao32.42 color2衡水市Hengshui8.37 color1重庆Chongqing18.59 color1上海Shanghai71.14 color4宁夏西宁市Xining60.22 color4海东地区Haidong18.44 color1海北州Haibei30.81 color2黄南州Huangnan89.12 color5海南州Hainan4.71 color1果洛州Guoluo17.90 color
19、1玉树州Yushu29.85 color2海西州Haixi55.00 color3湖南长沙市Changsha89.88 color5株洲市Zhuzhou85.86 color5湘潭市Xiangtan8.87 color1衡阳市Hengyang63.40 color4邵阳市Shaoyang21.83 color2岳阳市Yueyang98.42 color5常德市Changde23.31 color2张家界市Zhangjiajie65.19 color4益阳市Yiyang88.85 color5郴州市Chenzhou4.29 color1永州市Yongzhou44.40 color3怀化市Huai
20、hua21.28 color2娄底市Loudi88.94 color5湘西自治州xiangxi43.25 color3河南郑州市Zhengzhou78.95 color4开封市Kaifeng24.94 color2洛阳市Luoyang5.96 color1平顶山市Pingdingshan67.87 color4安阳市Anyang76.61 color4鹤壁市Hebi35.35 color2新乡市Xinxiang68.53 color4焦作市Jiaozuo92.03 color5濮阳市Puyang87.34 color5许昌市Xuchang43.78 color3漯河市Luohe28.20 co
21、lor2三门峡Sanmenxia74.57 color4南阳市Nanyang49.02 color3商丘市Shangqiu69.87 color4信阳市Xinyang22.88 color2周口市Zhoukou66.76 color4驻马店市Zhumadian40.64 color3济源市Jiyuan91.61 color5讲师南京Nanjing73.65 color4无锡Wuxi70.38 color4徐州Xuzhou28.32 color2常州Changzhou72.47 color4苏州Suzhou65.94 color4南通Nantong30.33 color2连云港Lianyunga
22、ng15.61 color1淮安Huaian25.82 color2盐城Yancheng45.30 color3扬州Yangzhou27.28 color2镇江Zhenjiang83.65 color5泰州TaizhouJS4.73 color1宿迁Suqian57.52 color3天津Tianjin26.57 color2广东广州Guangzhou56.13 color3深圳Shenzhen94.65 color5韶关Shaoguan81.42 color5珠海Zhuhai7.41 color1汕头Shantou92.10 color5佛山Fuoshan71.06 color4江门Jian
23、gmen12.74 color1湛江Zhanjiang37.30 color2茂名Maoming3.45 color1肇庆Zhaoqing81.92 color5惠州Huizhou97.39 color5梅州Meizhou68.92 color4汕尾Shanwei81.43 color5河源Heyuan57.33 color3阳江Yangjiang70.46 color4清远Qingyuan64.36 color4东莞Dongwan79.29 color4中山Zhongshan56.29 color3潮州Chaozhou78.64 color4揭阳Jieyang92.53 color5云浮Yu
24、nfu51.51 color3山东济南市Jinan86.98 color5青岛市Qingdao91.95 color5淄博市Zibo56.24 color3枣庄市Zaozhuang94.03 color5东营市Dongying8.83 color1烟台市Yantai84.40 color5潍坊市Weifang56.20 color3威海市Weihai0.90 color1泰安市Taian92.75 color5莱芜市Laiwu29.85 color2济宁市Jining39.28 color2临沂市Linyi36.35 color2日照市Rizhao87.20 color5德州市Dezhou5.
25、36 color1聊城市Liaocheng72.82 color4滨州市Binzhou64.88 color4菏泽市Heze10.66 color1山西临汾市Linfen90.85 color5晋中市Jinzhong83.43 color5阳泉市Yangquan70.97 color4大同市Datong4.56 color1运城市Yuncheng19.95 color1晋城市Jincheng64.45 color4朔州市Shuozhou50.92 color3吕梁市Lvliang62.04 color4长治市Changzhi66.00 color4忻州市Xinzhou46.64 color3太
26、原市Taiyuan97.36 color5甘肃兰州市lanzhou82.93 color5嘉峪关市Jiayuguan47.73 color3金昌市Jinchang64.35 color4白银市Baiyin77.11 color4天水市Tianshui42.45 color3武威市Wuwei72.44 color4张掖市Zhangye28.31 color2平凉市Pingliang69.92 color4酒泉市Jiuquan46.98 color3庆阳市Qingyang76.38 color4定西市Dingxi73.08 color4陇南市longnan6.03 color1临夏州Linxia1
27、1.61 color1甘南州Gannan51.30 color34、生成地图5、OK,复制走吧!color1color2color3color4color5http:/ExcelPhttp:/ by ExcelPro的图表博客3、设置阀值:输入分档的下限值以上预留了5个分档的位置,若需要可往下添加ExcelPro的的图图表表博博客客BengbuPuerHongheWenshanXishangbannaYuxiLincangShaotongDaliChuxiongDehongBaoshanDiqingNujiangLijiangKunmingQujingBaiseLiuzhouNanningGu
28、igangWuzhouQinzhouLaibinChongzuoGuilinHezhouHechiBeihaiFangchenggangYulinHaerbinQiqihaerMudanjiangJiamusiDaqingQitaiheSuihuaYichunJixiHeiheFuyangHuainanliuanHefeiyangzhouHegangShuangyashanDaxinganlingXianTongchuanBaojiWeinanYananHanzhongYulinAnkangShangluoXianyangShenyangDalianAnshanFushunBenxiDando
29、ngJinzhouYingkouFuxinLiaoyangTielingChaoyangPanjinHuludaoGuiyangZunyiAnshunQiannanQiandongnanTongrenBijieLiupanshuiQianxinanLasaRikezeChangduLinzhiShannanNaquAliFuzhouXiamenQuanzhouZhangzhouPutianSanmingNingdeLongyanNanpingWuhanHuangshiShiyanYichangXiangfanezhouJingmenXiaoganJingzhouHuanggangXiannin
30、gSuizhouEnshiShennongjiaTianmenQianjiangXiantaoHaikouSanyaHainanHangzhouNingboWenzhouJiaxingHuzhouShaoxingJinhuaQuzhouZhoushanTaizhouLishuiNanchangPingxiangJianXinyuJiujiangGanzhouJingdezhenShangraoYingtanYichunFuzhouUrumqiKaramayHamiTurpanBoertalaAletaiTachengChangjiYiliBayinguoleAkesuKezilesuKashg
31、arHotanChangchunJilinTonghuaSipingBaichengBaishanSongyuanLiaoyuanYanbianWuhuMaanshanHuaibeiTonglingAnqingHuangshanChuzhouBozhouSuzhouXuanchengChaohuChizhouYinchuanShizuishanWuzhongGuyuanZhongweiWuduZigongPanzhihuaLuzhouDeyangMianyangGuangyuanSuiningNeijiangLeshanYibinNanchongGuanganYaanAbaGanziBazho
32、ngMeishanZiyangDazhouChengduLiangshanHuhehaoteBaotouWuhaiChifengTongliaoEerduosiHulunbierWulanchabuBayanzhuoerXinganXilinguoleAlashanLangfangBeijingTianjinXingtaiShijiazhuangBaodingHandanTangshanChengdeCangzhouZhangjiakouQinhuangdaoHengshuiShanghaiChongqingXiningHaidongHaibeiHuangnanHainanGuoluoHaix
33、iYushuChangshaZhuzhouXiangtanHengyangShaoyangYueyangChangdeZhangjiajieYiyangChenzhouYongzhouHuaihuaXiangsiLoudiZhengzhouKaifengLuoyangPingdingshanAnyangHebiXinxiangJiaozuoPuyangXuchangLuoheSanmenxiaNanyangShangqiuXinyangZhoukouZhumadianJiyuanNanjingWuxiXuzhouChangzhouSuzhouNantongLianyungangHuaianSuqianYanchengZhenjiangTaizhouGuangzhouShenzhenShaoguanZhuhaiAomenXianggangShantouFuoshanJiangmenZhanj