中国数据地图-到市级.xls

中国数据地图-到市级.xls

《中国数据地图-到市级.xls》由会员分享，可在线阅读，更多相关《中国数据地图-到市级.xls（32页珍藏版）》请在冰点文库上搜索。

中国数据地图（到市级）生成模板地图绘制：

郑薇Vivi。

免责声明：

并不保证地市图形完全对应准确，商用请自行仔细核对无误。

模型建立：

ExcelPro的图表博客http:

/ExcelP2010.11.61、填入数据：

2、设置图例：

3、设置阀值：

在D列填入/粘贴数值G11:

H15将被作为图例输入分档的下限值数值：

填色：

云南德宏州Dehong0.00color110200红河州Honghe0.00color12204020临沧市Lincang0.00color13406040文山州Wenshan0.00color14608060昆明市Kunming0.00color1580+80曲靖市Qujing0.00color16+玉溪市Yuxi0.00color17昭通市Shaotong0.00color18大理州Dali0.00color19楚雄州Chuxiong0.00color110普洱市Puer0.00color1保山市Baoshan0.00color1以上预留了5个分档的位置，若需要可往下添加版纳州Xishuangbanna0.00color1迪庆州DiqingYN0.00color1怒江州Nujiang0.00color1丽江市Lijiang0.00color1广西南宁Nanning0.00color1柳州Liuzhou0.00color1以下仅为备用百色Baise0.00color1梧州Wuzhou0.00color1钦州Qinzhou0.00color1最小值：

0.00来宾Laibin0.00color1最大值：

0.00崇左Chongzuo0.00color1所分档数：

5桂林Guilin0.00color1间隔参考：

0贺州Hezhou0.00color1河池Hechi0.00color1北海Beihai0.00color1防城港Fangchenggang0.00color1贵港Guigang0.00color1玉林Yulin0.00color1黑龙江哈尔滨市Haerbin0.00color1齐齐哈尔市Qiqihaer0.00color1牡丹江市Mudanjiang0.00color1佳木斯市Jiamusi0.00color1ExcelPro的的图图表表博博客客大庆市Daqing0.00color1七台河市Qitaihe0.00color1搜狐博客：

绥化市Suihua0.00color1新浪微博：

伊春市YichunHLJ0.00color1豆瓣读书：

鸡西市Jixi0.00color1图表之道：

黑河市Heihe0.00color1图表书架：

鹤岗Hegang0.00color1双鸭山Shuangyashan0.00color1大兴安岭地区Daxinganling0.00color1陕西西安市Xian0.00color1铜川市Tongchuan0.00color1宝鸡市Baoji0.00color1咸阳+杨凌市Xianyang0.00color1渭南市Weinan0.00color1延安市Yanan0.00color1汉中市Hanzhong0.00color1榆林市YulinSX0.00color1安康市Ankang0.00color1商洛市Shangluo0.00color1辽宁沈阳Shenyang0.00color1大连Dalian0.00color1鞍山Anshan0.00color1抚顺Fushun0.00color1本溪Benxi0.00color1丹东Dandong0.00color1锦州Jinzhou0.00color1营口Yingkou0.00color1阜新Fuxin0.00color1辽阳Liaoyang0.00color1铁岭Tieling0.00color1朝阳Chaoyang0.00color1盘锦Panjin0.00color1葫芦岛Huludao0.00color1贵阳市Guiyang0.00color1遵义市Zunyi0.00color1安顺市Anshun0.00color1黔南州Qiannan0.00color1黔东南州Qiandongnan0.00color1铜仁地区Tongren0.00color1毕节地区Bijie0.00color1六盘水市Liupanshui0.00color1黔西南州Qianxinan0.00color1西藏拉萨市Lasa0.00color1日喀则Rikeze0.00color1昌都Changdu0.00color1林芝Linzhi0.00color1山南Shannan0.00color1阿里Ali0.00color1那曲Naqu0.00color1福建福州Fuzhou0.00color1厦门Xiamen0.00color1泉州Quanzhou0.00color1漳州Zhangzhou0.00color1莆田Putian0.00color1三明Sanming0.00color1宁德Ningde0.00color1龙岩Longyan0.00color1南平Nanping0.00color1湖北武汉市Wuhan0.00color1黄石市Huangshi0.00color1十堰市Shiyan0.00color1宜昌Yichang0.00color1襄樊市Xiangfan0.00color1鄂州Ezhou0.00color1荆门市Jingmen0.00color1孝感市Xiaogan0.00color1荆州市Jingzhou0.00color1黄冈市Huanggang0.00color1咸宁市Xianning0.00color1随州Suizhou0.00color1恩施州Enshi0.00color1神农架林区Shennongjia0.00color1天门市Tianmen0.00color1潜江Qianjiang0.00color1仙桃市Xiantao0.00color1海南海口市Haikou0.00color1三亚市Sanya0.00color1海南其它HainanQT0.00color1浙江杭州市Hangzhou0.00color1宁波市Ningbo0.00color1温州市Wenzhou0.00color1嘉兴市Jiaxing0.00color1湖州市Huzhou0.00color1绍兴市Shaoxing0.00color1金华市Jinhua0.00color1衢州市Quzhou0.00color1舟山市Zhoushan0.00color1台州市Taizhou0.00color1丽水市Lishui0.00color1江西南昌市Nanchang0.00color1萍乡市Pingxiang0.00color1新余市Xinyu0.00color1九江市Jiujiang0.00color1抚州市FuzhouJX0.00color1赣州市Ganzhou0.00color1景德镇市Jingdezhen0.00color1吉安市Jian0.00color1上饶市Shangrao0.00color1宜春市Yichun0.00color1鹰潭市Yingtan0.00color1新疆乌鲁木齐市Urumqi0.00color1克拉玛依市Karamay0.00color1哈密地区Hami0.00color1吐鲁番地区Turpan0.00color1博州Boertala0.00color1阿勒泰地区Aletai0.00color1塔城地区Tacheng0.00color1昌吉州Changji0.00color1伊犁州直Yili0.00color1巴州Bayinguole0.00color1阿克苏地区Akesu0.00color1克州Kezilesu0.00color1喀什地区Kashgar0.00color1和田地区Hotan0.00color1吉林长春Changchun0.00color1吉林Jilin0.00color1通化Tonghua0.00color1四平Siping0.00color1白城Baicheng0.00color1白山Baishan0.00color1松源Songyuan0.00color1辽源Liaoyuan0.00color1延边Yanbian0.00color1安徽合肥市Hefei0.00color1芜湖市Wuhu0.00color1蚌埠市Bengbu0.00color1淮南市Huainan0.00color1马鞍山市Maanshan0.00color1淮北市Huaibei0.00color1铜陵市Tongling0.00color1安庆市Anqing0.00color1黄山市Huangshan0.00color1滁州市Chuzhou0.00color1阜阳市Fuyang0.00color1亳州市bozhou0.00color1宿州市SuzhouAH0.00color1六安市Liuan0.00color1宣城市Xuancheng0.00color1巢湖市Chaohu0.00color1池州市Chizhou0.00color1银川市Yinchuan0.00color1石嘴山市Shizuishan0.00color1吴忠市Wuzhong0.00color1固原市Guyuan0.00color1中卫市Zhongwei0.00color1凉山Liangshan0.00color1四川成都Chengdu0.00color1自贡Zigong0.00color1攀枝花Panzhihua0.00color1泸州Luzhou0.00color1德阳Deyang0.00color1绵阳Mianyang0.00color1广元Guangyuan0.00color1遂宁Suining0.00color1内江Neijiang0.00color1乐山Leshan0.00color1南充Nanchong0.00color1宜宾Yibin0.00color1广安Guangan0.00color1雅安Yaan0.00color1阿坝州Aba0.00color1甘孜州Ganzi0.00color1巴中Bazhong0.00color1眉山Meishan0.00color1资阳Ziyang0.00color1达州Dazhou0.00color1北京Beijing0.00color1内蒙古呼和浩特市huhehaote0.00color1包头市Baotou0.00color1乌海市Wuhai0.00color1赤峰市Chifeng0.00color1通辽市Tongliao0.00color1鄂尔多斯市Eerduosi0.00color1呼伦贝尔市Hulunbier0.00color1乌兰察布市Wulanchabu0.00color1巴彦淖尔市Bayanzhuoer0.00color1兴安盟Xingan0.00color1锡林郭勒盟Xilinguole0.00color1阿拉善盟Alashan0.00color1河北廊坊Langfang0.00color1邢台市Xingtai0.00color1石家庄Shijiazhuang0.00color1保定市Baoding0.00color1邯郸市Handan0.00color1唐山市Tangshan0.00color1承德市Chengde0.00color1沧州市Cangzhou0.00color1张家口市Zhangjiakou0.00color1秦皇岛市Qinhuangdao0.00color1衡水市Hengshui0.00color1重庆Chongqing0.00color1上海Shanghai0.00color1宁夏西宁市Xining0.00color1海东地区Haidong0.00color1海北州Haibei0.00color1黄南州Huangnan0.00color1海南州Hainan0.00color1果洛州Guoluo0.00color1玉树州Yushu0.00color1海西州Haixi0.00color1湖南长沙市Changsha0.00color1株洲市Zhuzhou0.00color1湘潭市Xiangtan0.00color1衡阳市Hengyang0.00color1邵阳市Shaoyang0.00color1岳阳市Yueyang0.00color1常德市Changde0.00color1张家界市Zhangjiajie0.00color1益阳市Yiyang0.00color1郴州市Chenzhou0.00color1永州市Yongzhou0.00color1怀化市Huaihua0.00color1娄底市Loudi0.00color1湘西自治州xiangxi0.00color1河南郑州市Zhengzhou0.00color1开封市Kaifeng0.00color1洛阳市Luoyang0.00color1平顶山市Pingdingshan0.00color1安阳市Anyang0.00color1鹤壁市Hebi0.00color1新乡市Xinxiang0.00color1焦作市Jiaozuo0.00color1濮阳市Puyang0.00color1许昌市Xuchang0.00color1漯河市Luohe0.00color1三门峡Sanmenxia0.00color1南阳市Nanyang0.00color1商丘市Shangqiu0.00color1信阳市Xinyang0.00color1周口市Zhoukou0.00color1驻马店市Zhumadian0.00color1济源市Jiyuan0.00color1讲师南京Nanjing0.00color1无锡Wuxi0.00color1徐州Xuzhou0.00color1常州Changzhou0.00color1苏州Suzhou0.00color1南通Nantong0.00color1连云港Lianyungang0.00color1淮安Huaian0.00color1盐城Yancheng0.00color1扬州Yangzhou0.00color1镇江Zhenjiang0.00color1泰州TaizhouJS0.00color1宿迁Suqian0.00color1天津Tianjin0.00color1广东广州Guangzhou0.00color1深圳Shenzhen0.00color1韶关Shaoguan0.00color1珠海Zhuhai0.00color1汕头Shantou0.00color1佛山Fuoshan0.00color1江门Jiangmen0.00color1湛江Zhanjiang0.00color1茂名Maoming0.00color1肇庆Zhaoqing0.00color1惠州Huizhou0.00color1梅州Meizhou0.00color1汕尾Shanwei0.00color1河源Heyuan0.00color1阳江Yangjiang0.00color1清远Qingyuan0.00color1东莞Dongwan0.00color1中山Zhongshan0.00color1潮州Chaozhou0.00color1揭阳Jieyang0.00color1云浮Yunfu0.00color1山东济南市Jinan0.00color1青岛市Qingdao0.00color1淄博市Zibo0.00color1枣庄市Zaozhuang0.00color1东营市Dongying0.00color1烟台市Yantai0.00color1潍坊市Weifang0.00color1威海市Weihai0.00color1泰安市Taian0.00color1莱芜市Laiwu0.00color1济宁市Jining0.00color1临沂市Linyi0.00color1日照市Rizhao0.00color1德州市Dezhou0.00color1聊城市Liaocheng0.00color1滨州市Binzhou0.00color1菏泽市Heze0.00color1山西临汾市Linfen0.00color1晋中市Jinzhong0.00color1阳泉市Yangquan0.00color1大同市Datong0.00color1运城市Yuncheng0.00color1晋城市Jincheng0.00color1朔州市Shuozhou0.00color1吕梁市Lvliang0.00color1长治市Changzhi0.00color1忻州市Xinzhou0.00color1太原市Taiyuan0.00color1甘肃兰州市lanzhou0.00color1嘉峪关市Jiayuguan0.00color1金昌市Jinchang0.00color1白银市Baiyin0.00color1天水市Tianshui0.00color1武威市Wuwei0.00color1张掖市Zhangye0.00color1平凉市Pingliang0.00color1酒泉市Jiuquan0.00color1庆阳市Qingyang0.00color1定西市Dingxi0.00color1陇南市longnan0.00color1临夏州Linxia0.00color1甘南州Gannan0.00color14、生成地图5、OK，复制走吧！

color1color2color3color4color5http:

/ExcelPhttp:

/byExcelPro的图表博客3、设置阀值：

输入分档的下限值以上预留了5个分档的位置，若需要可往下添加ExcelPro的的图图表表博博客客BengbuPuerHongheWenshanXishangbannaYuxiLincangShaotongDaliChuxiongDehongBaoshanDiqingNujiangLijiangKunmingQujingBaiseLiuzhouNanningGuigangWuzhouQinzhouLaibinChongzuoGuilinHezhouHechiBeihaiFangchenggangYulinHaerbinQiqihaerMudanjiangJiamusiDaqingQitaiheSuihuaYichunJixiHeiheFuyangHuainanliuanHefeiyangzhouHegangShuangyashanDaxinganlingXianTongchuanBaojiWeinanYananHanzhongYulinAnkangShangluoXianyangShenyangDalianAnshanFushunBenxiDandongJinzhouYingkouFuxinLiaoyangTielingChaoyangPanjinHuludaoGuiyangZunyiAnshunQiannanQiandongnanTongrenBijieLiupanshuiQianxinanLasaRikezeChangduLinzhiShannanNaquAliFuzhouXiamenQuanzhouZhangzhouPutianSanmingNingdeLongyanNanpingWuhanHuangshiShiyanYichangXiangfanezhouJingmenXiaoganJingzhouHuanggangXianningSuizhouEnshiShennongjiaTianmenQianjiangXiantaoHaikouSanyaHainanHangzhouNingboWenzhouJiaxingHuzhouShaoxingJinhuaQuzhouZhoushanTaizhouLishuiNanchangPingxiangJianXinyuJiujiangGanzhouJingdezhenShangraoYingtanYichunFuzhouUrumqiKaramayHamiTurpanBoertalaAletaiTachengChangjiYiliBayinguoleAkesuKezilesuKashgarHotanChangchunJilinTonghuaSipingBaichengBaishanSongyuanLiaoyuanYanbianWuhuMaanshanHuaibeiTonglingAnqingHuangshanChuzhouBozhouSuzhouXuanchengChaohuChizhouYinchuanShizuishanWuzhongGuyuanZhongweiWuduZigongPanzhihuaLuzhouDeyangMianyangGuangyuanSuiningNeijiangLeshanYibinNanchongGuanganYaanAbaGanziBazhongMeishanZiyangDazhouChengduLiangshanHuhehaoteBaotouWuhaiChifengTongliaoEerduosiHulunbierWulanchabuBayanzhuoerXinganXilinguoleAlashanLangfangBeijingTianjinXingtaiShijiazhuangBaodingHandanTangshanChengdeCangzhouZhangjiakouQinhuangdaoHengshuiShanghaiChongqingXiningHaidongHaibeiHuangnanHainanGuoluoHaixiYushuChangshaZhuzhouXiangtanHengyangShaoyangYueyangChangdeZhangjiajieYiyangChenzhouYongzhouHuaihuaXiangsiLoudiZhengzhouKaifengLuoyangPingdingshanAnyangHebiXinxiangJiaozuoPuyangXuchangLuoheSanmenxiaNanyangShangqiuXinyangZhoukouZhumadianJiyuanNanjingWuxiXuzhouChangzhouSuzhouNantongLianyungangHuaianSuqianYanchengZhenjiangTaizhouGuangzhouShenzhenShaoguanZhuhaiAomenXianggangShantouFuoshanJiangmenZhanjiangMaomingZhaoqingHuizhouMeizhouShanweiHeyuanYangjiangQingyuanDongwanzhongshanJieyangChaozhouYunfuJinanQingdaoZiboZaozhuangDongyingYantaiWeihaiTaianWeifangLaiwuJiningLinyiRizhaoDezhouHezeBinzhouLiaochengLinfenJinzhongYangquanDatongYunchengJinchengShuozhouLvliangChangzhiXinzhouTaiyuanJiuquanTaiwan02020404060608080