1、免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。模型建立:ExcelPro的图表博客http:/ExcelP2010.11.61、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong0.00 color110200红河州Honghe0.00 color12204020临沧市Lincang0.00 color13406040文山州Wenshan0.00 color14608060昆明市Kunming0.00 color1580+80曲靖市Qujing0.00 color16+玉溪市Yuxi0.00
2、color17昭通市Shaotong0.00 color18大理州Dali0.00 color19楚雄州Chuxiong0.00 color110普洱市Puer0.00 color1保山市Baoshan0.00 color1以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna 0.00 color1迪庆州DiqingYN0.00 color1怒江州Nujiang0.00 color1丽江市Lijiang0.00 color1广西南宁Nanning0.00 color1柳州Liuzhou0.00 color1以下仅为备用百色Baise0.00 color1梧州Wuzhou0
3、.00 color1钦州Qinzhou0.00 color1最小值:0.00来宾Laibin0.00 color1最大值:0.00崇左Chongzuo0.00 color1所分档数:5桂林Guilin0.00 color1间隔参考:0贺州Hezhou0.00 color1河池Hechi0.00 color1北海Beihai0.00 color1防城港Fangchenggang 0.00 color1贵港Guigang0.00 color1玉林Yulin0.00 color1黑龙江哈尔滨市Haerbin0.00 color1齐齐哈尔市Qiqihaer0.00 color1牡丹江市Mudanjia
4、ng0.00 color1佳木斯市 Jiamusi0.00 color1ExcelPro的的图图表表博博客客大庆市Daqing0.00 color1七台河市Qitaihe0.00 color1搜狐博客:绥化市Suihua0.00 color1新浪微博:伊春市YichunHLJ0.00 color1豆瓣读书:鸡西市Jixi0.00 color1图表之道:黑河市Heihe0.00 color1图表书架:鹤岗Hegang0.00 color1双鸭山Shuangyashan0.00 color1大兴安岭地区Daxinganling0.00 color1陕西西安市Xian0.00 color1铜川市To
5、ngchuan0.00 color1宝鸡市Baoji0.00 color1咸阳+杨凌市 Xianyang0.00 color1渭南市Weinan0.00 color1延安市Yanan0.00 color1汉中市Hanzhong0.00 color1榆林市YulinSX0.00 color1安康市Ankang0.00 color1商洛市Shangluo0.00 color1辽宁沈阳Shenyang0.00 color1大连Dalian0.00 color1鞍山Anshan0.00 color1抚顺Fushun0.00 color1本溪Benxi0.00 color1丹东Dandong0.00 c
6、olor1锦州Jinzhou0.00 color1营口Yingkou0.00 color1阜新Fuxin0.00 color1辽阳Liaoyang0.00 color1铁岭Tieling0.00 color1朝阳Chaoyang0.00 color1盘锦Panjin0.00 color1葫芦岛Huludao0.00 color1贵阳市Guiyang0.00 color1遵义市Zunyi0.00 color1安顺市Anshun0.00 color1黔南州Qiannan0.00 color1黔东南州Qiandongnan0.00 color1铜仁地区Tongren0.00 color1毕节地区Bi
7、jie0.00 color1六盘水市Liupanshui0.00 color1黔西南州Qianxinan0.00 color1西藏拉萨市Lasa0.00 color1日喀则Rikeze0.00 color1昌都Changdu0.00 color1林芝Linzhi0.00 color1山南Shannan0.00 color1阿里Ali0.00 color1那曲Naqu0.00 color1福建福州Fuzhou0.00 color1厦门Xiamen0.00 color1泉州Quanzhou0.00 color1漳州Zhangzhou0.00 color1莆田Putian0.00 color1三明S
8、anming0.00 color1宁德Ningde0.00 color1龙岩Longyan0.00 color1南平Nanping0.00 color1湖北武汉市Wuhan0.00 color1黄石市Huangshi0.00 color1十堰市Shiyan0.00 color1宜昌Yichang0.00 color1襄樊市Xiangfan0.00 color1鄂州Ezhou0.00 color1荆门市Jingmen0.00 color1孝感市Xiaogan0.00 color1荆州市Jingzhou0.00 color1黄冈市Huanggang0.00 color1咸宁市Xianning0.0
9、0 color1随州Suizhou0.00 color1恩施州Enshi0.00 color1神农架林区Shennongjia0.00 color1天门市Tianmen0.00 color1潜江Qianjiang0.00 color1仙桃市Xiantao0.00 color1海南海口市Haikou0.00 color1三亚市Sanya0.00 color1海南其它HainanQT0.00 color1浙江杭州市Hangzhou0.00 color1宁波市Ningbo0.00 color1温州市Wenzhou0.00 color1嘉兴市Jiaxing0.00 color1湖州市Huzhou0.0
10、0 color1绍兴市Shaoxing0.00 color1金华市Jinhua0.00 color1衢州市Quzhou0.00 color1舟山市Zhoushan0.00 color1台州市Taizhou0.00 color1丽水市Lishui0.00 color1江西南昌市Nanchang0.00 color1萍乡市Pingxiang0.00 color1新余市Xinyu0.00 color1九江市Jiujiang0.00 color1抚州市FuzhouJX0.00 color1赣州市Ganzhou0.00 color1景德镇市Jingdezhen0.00 color1吉安市Jian0.00
11、 color1上饶市Shangrao0.00 color1宜春市Yichun0.00 color1鹰潭市Yingtan0.00 color1新疆乌鲁木齐市Urumqi0.00 color1克拉玛依市Karamay0.00 color1哈密地区Hami0.00 color1吐鲁番地区Turpan0.00 color1博州Boertala0.00 color1阿勒泰地区Aletai0.00 color1塔城地区Tacheng0.00 color1昌吉州Changji0.00 color1伊犁州直Yili0.00 color1巴州Bayinguole0.00 color1阿克苏地区Akesu0.00
12、 color1克州Kezilesu0.00 color1喀什地区Kashgar0.00 color1和田地区Hotan0.00 color1吉林长春Changchun0.00 color1吉林Jilin0.00 color1通化Tonghua0.00 color1四平Siping0.00 color1白城Baicheng0.00 color1白山Baishan0.00 color1松源Songyuan0.00 color1辽源Liaoyuan0.00 color1延边Yanbian0.00 color1安徽合肥市Hefei0.00 color1芜湖市Wuhu0.00 color1蚌埠市Beng
13、bu0.00 color1淮南市Huainan0.00 color1马鞍山市Maanshan0.00 color1淮北市Huaibei0.00 color1铜陵市Tongling0.00 color1安庆市Anqing0.00 color1黄山市Huangshan0.00 color1滁州市Chuzhou0.00 color1阜阳市Fuyang0.00 color1亳州市bozhou0.00 color1宿州市SuzhouAH0.00 color1六安市Liuan0.00 color1宣城市Xuancheng0.00 color1巢湖市Chaohu0.00 color1池州市Chizhou0.
14、00 color1银川市Yinchuan0.00 color1石嘴山市Shizuishan0.00 color1吴忠市Wuzhong0.00 color1固原市Guyuan0.00 color1中卫市Zhongwei0.00 color1凉山Liangshan0.00 color1四川成都Chengdu0.00 color1自贡Zigong0.00 color1攀枝花Panzhihua0.00 color1泸州Luzhou0.00 color1德阳Deyang0.00 color1绵阳Mianyang0.00 color1广元Guangyuan0.00 color1遂宁Suining0.00
15、color1内江Neijiang0.00 color1乐山Leshan0.00 color1南充Nanchong0.00 color1宜宾Yibin0.00 color1广安Guangan0.00 color1雅安Yaan0.00 color1阿坝州Aba0.00 color1甘孜州Ganzi0.00 color1巴中Bazhong0.00 color1眉山Meishan0.00 color1资阳Ziyang0.00 color1达州Dazhou0.00 color1北京Beijing0.00 color1内蒙古呼和浩特市huhehaote0.00 color1包头市Baotou0.00 co
16、lor1乌海市Wuhai0.00 color1赤峰市Chifeng0.00 color1通辽市Tongliao0.00 color1鄂尔多斯市Eerduosi0.00 color1呼伦贝尔市Hulunbier0.00 color1乌兰察布市Wulanchabu0.00 color1巴彦淖尔市Bayanzhuoer0.00 color1兴安盟Xingan0.00 color1锡林郭勒盟Xilinguole0.00 color1阿拉善盟Alashan0.00 color1河北廊坊 Langfang0.00 color1邢台市Xingtai0.00 color1石家庄Shijiazhuang0.00
17、 color1保定市Baoding0.00 color1邯郸市 Handan0.00 color1唐山市 Tangshan0.00 color1承德市Chengde0.00 color1沧州市Cangzhou0.00 color1张家口市Zhangjiakou0.00 color1秦皇岛市Qinhuangdao0.00 color1衡水市Hengshui0.00 color1重庆Chongqing0.00 color1上海Shanghai0.00 color1宁夏西宁市Xining0.00 color1海东地区Haidong0.00 color1海北州Haibei0.00 color1黄南州H
18、uangnan0.00 color1海南州Hainan0.00 color1果洛州Guoluo0.00 color1玉树州Yushu0.00 color1海西州Haixi0.00 color1湖南长沙市Changsha0.00 color1株洲市Zhuzhou0.00 color1湘潭市Xiangtan0.00 color1衡阳市Hengyang0.00 color1邵阳市Shaoyang0.00 color1岳阳市Yueyang0.00 color1常德市Changde0.00 color1张家界市Zhangjiajie0.00 color1益阳市Yiyang0.00 color1郴州市Ch
19、enzhou0.00 color1永州市Yongzhou0.00 color1怀化市Huaihua0.00 color1娄底市Loudi0.00 color1湘西自治州xiangxi0.00 color1河南郑州市Zhengzhou0.00 color1开封市Kaifeng0.00 color1洛阳市Luoyang0.00 color1平顶山市Pingdingshan0.00 color1安阳市Anyang0.00 color1鹤壁市Hebi0.00 color1新乡市Xinxiang0.00 color1焦作市Jiaozuo0.00 color1濮阳市Puyang0.00 color1许昌市
20、Xuchang0.00 color1漯河市Luohe0.00 color1三门峡Sanmenxia0.00 color1南阳市Nanyang0.00 color1商丘市Shangqiu0.00 color1信阳市Xinyang0.00 color1周口市Zhoukou0.00 color1驻马店市Zhumadian0.00 color1济源市Jiyuan0.00 color1讲师南京Nanjing0.00 color1无锡Wuxi0.00 color1徐州Xuzhou0.00 color1常州Changzhou0.00 color1苏州Suzhou0.00 color1南通Nantong0.0
21、0 color1连云港Lianyungang0.00 color1淮安Huaian0.00 color1盐城Yancheng0.00 color1扬州Yangzhou0.00 color1镇江Zhenjiang0.00 color1泰州TaizhouJS0.00 color1宿迁Suqian0.00 color1天津Tianjin0.00 color1广东广州Guangzhou0.00 color1深圳Shenzhen0.00 color1韶关Shaoguan0.00 color1珠海Zhuhai0.00 color1汕头Shantou0.00 color1佛山Fuoshan0.00 colo
22、r1江门Jiangmen0.00 color1湛江Zhanjiang0.00 color1茂名Maoming0.00 color1肇庆Zhaoqing0.00 color1惠州Huizhou0.00 color1梅州Meizhou0.00 color1汕尾Shanwei0.00 color1河源Heyuan0.00 color1阳江Yangjiang0.00 color1清远Qingyuan0.00 color1东莞Dongwan0.00 color1中山Zhongshan0.00 color1潮州Chaozhou0.00 color1揭阳Jieyang0.00 color1云浮Yunfu0.
23、00 color1山东济南市Jinan0.00 color1青岛市Qingdao0.00 color1淄博市Zibo0.00 color1枣庄市Zaozhuang0.00 color1东营市Dongying0.00 color1烟台市Yantai0.00 color1潍坊市Weifang0.00 color1威海市Weihai0.00 color1泰安市Taian0.00 color1莱芜市Laiwu0.00 color1济宁市Jining0.00 color1临沂市Linyi0.00 color1日照市Rizhao0.00 color1德州市Dezhou0.00 color1聊城市Liaoc
24、heng0.00 color1滨州市Binzhou0.00 color1菏泽市Heze0.00 color1山西临汾市Linfen0.00 color1晋中市Jinzhong0.00 color1阳泉市Yangquan0.00 color1大同市Datong0.00 color1运城市Yuncheng0.00 color1晋城市Jincheng0.00 color1朔州市Shuozhou0.00 color1吕梁市Lvliang0.00 color1长治市Changzhi0.00 color1忻州市Xinzhou0.00 color1太原市Taiyuan0.00 color1甘肃兰州市lanz
25、hou0.00 color1嘉峪关市Jiayuguan0.00 color1金昌市Jinchang0.00 color1白银市Baiyin0.00 color1天水市Tianshui0.00 color1武威市Wuwei0.00 color1张掖市Zhangye0.00 color1平凉市Pingliang0.00 color1酒泉市Jiuquan0.00 color1庆阳市Qingyang0.00 color1定西市Dingxi0.00 color1陇南市longnan0.00 color1临夏州Linxia0.00 color1甘南州Gannan0.00 color14、生成地图5、OK,
26、复制走吧!color1color2color3color4color5http:/ExcelPhttp:/ by ExcelPro的图表博客3、设置阀值:输入分档的下限值以上预留了5个分档的位置,若需要可往下添加ExcelPro的的图图表表博博客客BengbuPuerHongheWenshanXishangbannaYuxiLincangShaotongDaliChuxiongDehongBaoshanDiqingNujiangLijiangKunmingQujingBaiseLiuzhouNanningGuigangWuzhouQinzhouLaibinChongzuoGuilinHezho
27、uHechiBeihaiFangchenggangYulinHaerbinQiqihaerMudanjiangJiamusiDaqingQitaiheSuihuaYichunJixiHeiheFuyangHuainanliuanHefeiyangzhouHegangShuangyashanDaxinganlingXianTongchuanBaojiWeinanYananHanzhongYulinAnkangShangluoXianyangShenyangDalianAnshanFushunBenxiDandongJinzhouYingkouFuxinLiaoyangTielingChaoyan
28、gPanjinHuludaoGuiyangZunyiAnshunQiannanQiandongnanTongrenBijieLiupanshuiQianxinanLasaRikezeChangduLinzhiShannanNaquAliFuzhouXiamenQuanzhouZhangzhouPutianSanmingNingdeLongyanNanpingWuhanHuangshiShiyanYichangXiangfanezhouJingmenXiaoganJingzhouHuanggangXianningSuizhouEnshiShennongjiaTianmenQianjiangXia
29、ntaoHaikouSanyaHainanHangzhouNingboWenzhouJiaxingHuzhouShaoxingJinhuaQuzhouZhoushanTaizhouLishuiNanchangPingxiangJianXinyuJiujiangGanzhouJingdezhenShangraoYingtanYichunFuzhouUrumqiKaramayHamiTurpanBoertalaAletaiTachengChangjiYiliBayinguoleAkesuKezilesuKashgarHotanChangchunJilinTonghuaSipingBaichengB
30、aishanSongyuanLiaoyuanYanbianWuhuMaanshanHuaibeiTonglingAnqingHuangshanChuzhouBozhouSuzhouXuanchengChaohuChizhouYinchuanShizuishanWuzhongGuyuanZhongweiWuduZigongPanzhihuaLuzhouDeyangMianyangGuangyuanSuiningNeijiangLeshanYibinNanchongGuanganYaanAbaGanziBazhongMeishanZiyangDazhouChengduLiangshanHuheha
31、oteBaotouWuhaiChifengTongliaoEerduosiHulunbierWulanchabuBayanzhuoerXinganXilinguoleAlashanLangfangBeijingTianjinXingtaiShijiazhuangBaodingHandanTangshanChengdeCangzhouZhangjiakouQinhuangdaoHengshuiShanghaiChongqingXiningHaidongHaibeiHuangnanHainanGuoluoHaixiYushuChangshaZhuzhouXiangtanHengyangShaoya
32、ngYueyangChangdeZhangjiajieYiyangChenzhouYongzhouHuaihuaXiangsiLoudiZhengzhouKaifengLuoyangPingdingshanAnyangHebiXinxiangJiaozuoPuyangXuchangLuoheSanmenxiaNanyangShangqiuXinyangZhoukouZhumadianJiyuanNanjingWuxiXuzhouChangzhouSuzhouNantongLianyungangHuaianSuqianYanchengZhenjiangTaizhouGuangzhouShenzh
33、enShaoguanZhuhaiAomenXianggangShantouFuoshanJiangmenZhanjiangMaomingZhaoqingHuizhouMeizhouShanweiHeyuanYangjiangQingyuanDongwanzhongshanJieyangChaozhouYunfuJinanQingdaoZiboZaozhuangDongyingYantaiWeihaiTaianWeifangLaiwuJiningLinyiRizhaoDezhouHezeBinzhouLiaochengLinfenJinzhongYangquanDatongYunchengJinchengShuozhouLvliangChangzhiXinzhouTaiyuanJiuquanTaiwan02020404060608080