下载文档原格式
中国数据地图工具只要您输入各省数据，设置分档数值和填充底色，即可快[原创] ExcelPro 的图表博客 红色标注标识下的填色区域为您需要填的地方。
不要修改1、输入你的数据，没有的可填0。
--->>>2、设置数据分档及图例。
--->>>安徽anhui 288.66分档参考：0color1北京beijing 491.71100color2重庆chongqing 156.49最大值：938.86200color3福建fujian 429.33最小值：49.33500color4甘肃gansu 149.52800color5广东guangdong 817.58广西guangxi 938.86贵州guizhou 580.90海南hainan 642.06河北hebei 755.23黑龙江heilongjiang 581.01河南henan 674.80湖北hubei 610.15湖南hunan 308.92江苏jiangsu 712.37江西jiangxi 598.14吉林jilin 663.27辽宁liaoning 418.85内蒙古neimenggu 208.74宁夏ninxia 93.76青海qinghai 898.04山东shandong 300.92上海shanghai 401.41陕西shanxi3368.93山西shanxi149.80四川sichuan 428.59台湾taiwan 292.26天津tianjin 819.68新疆xinjiang 750.85西藏xizang 923.94云南yunnan 49.33浙江zhejiang755.29档数值和填充底色，即可快速生成专业的中国数据地图！您需要填的地方。
不要修改其他地方，以免出现错误。
3、点击按钮开始填色。
--->>>4、OK ！可以复制下面的数据地图了。
您可根据此文件改造出成省、市的分区数据地图！0-100100-200200-500500-800800+。
中国数据地图（到市级）生成模板地图绘制：郑薇 Vivi。
免责声明：并不保证地市图形完全对应准确，商用请自行仔细核对无误。
模型建立：ExcelPro的图表博客2010.11.61、填入数据：2、设置图例：3、设置阀值：在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值：填色：云南德宏州Dehong78.58color40红河州Honghe40.02color320临沧市Lincang45.86color340文山州Wenshan17.69color160昆明市Kunming43.43color380曲靖市Qujing33.37color2+玉溪市Yuxi87.87color57昭通市Shaotong32.91color28大理州Dali60.24color49楚雄州Chuxiong50.06color310普洱市Puer74.60color4保山市Baoshan67.10color4以上预留了5个分档的位置，若需要可往下添加版纳州Xishuangbann20.94color2迪庆州DiqingYN63.23color4怒江州Nujiang67.84color4丽江市Lijiang 5.97color1广西南宁Nanning10.57color1柳州Liuzhou11.89color1以下仅为备用百色Baise7.65color1梧州Wuzhou7.45color1钦州Qinzhou0.08color1最小值：0.08来宾Laibin55.58color3最大值：99.97崇左Chongzuo79.59color4所分档数：5桂林Guilin81.89color5间隔参考：19.97844贺州Hezhou76.93color4河池Hechi 1.18color1北海Beihai38.07color2防城港Fangchengga52.24color3贵港Guigang8.18color1玉林Yulin40.65color3黑龙江哈尔滨市Haerbin21.76color2齐齐哈尔市Qiqihaer83.94color5牡丹江市Mudanjiang98.31color5佳木斯市Jiamusi25.55color2ExcelPro的图表博客大庆市Daqing45.63color3七台河市Qitaihe7.76color1搜狐博客：绥化市Suihua57.99color3新浪微博：伊春市YichunHLJ 2.89color1豆瓣读书：鸡西市Jixi 2.88color1图表之道：黑河市Heihe62.27color4图表书架：鹤岗Hegang8.84color1双鸭山Shuangyasha 4.06color1大兴安岭地区D axinganling99.97color5陕西西安市Xian13.60color1铜川市Tongchuan 2.95color1宝鸡市Baoji43.33color3咸阳+杨凌市Xianyang45.59color3渭南市Weinan77.69color4延安市Yanan78.27color4汉中市Hanzhong53.16color3榆林市YulinSX81.62color5安康市Ankang36.17color2商洛市Shangluo56.18color3辽宁沈阳Shenyang72.51color4大连Dalian77.49color4鞍山Anshan46.29color3抚顺Fushun78.93color4本溪Benxi89.44color5丹东Dandong73.83color4锦州Jinzhou46.67color3营口Yingkou26.31color2阜新Fuxin0.29color1辽阳Liaoyang97.23color5铁岭Tieling31.61color2朝阳Chaoyang64.73color4盘锦Panjin9.32color1葫芦岛Huludao51.77color3贵阳市Guiyang79.85color4遵义市Zunyi10.24color1安顺市Anshun93.04color5黔南州Qiannan19.57color1黔东南州Qiandongnan38.07color2铜仁地区Tongren64.83color4毕节地区Bijie36.79color2六盘水市Liupanshui79.99color4黔西南州Qianxinan50.47color3西藏拉萨市Lasa89.57color5日喀则Rikeze74.85color4昌都Changdu92.80color5林芝Linzhi0.17color1山南Shannan58.92color3阿里Ali73.67color4那曲Naqu33.32color2福建福州Fuzhou18.06color1厦门Xiamen0.59color1泉州Quanzhou99.94color5漳州Zhangzhou69.16color4莆田Putian84.73color5三明Sanming97.12color5宁德Ningde44.16color3龙岩Longyan17.80color1南平Nanping68.32color4湖北武汉市Wuhan79.04color4黄石市Huangshi81.60color5十堰市Shiyan88.10color5宜昌Yichang63.51color4襄樊市Xiangfan94.45color5鄂州Ezhou80.75color5荆门市Jingmen78.05color4孝感市Xiaogan39.19color2荆州市Jingzhou45.12color3黄冈市Huanggang71.03color4咸宁市Xianning12.49color1随州Suizhou40.98color3恩施州Enshi79.28color4神农架林区Shennongjia71.01color4天门市Tianmen15.44color1潜江Qianjiang55.07color3仙桃市Xiantao13.90color1海南海口市Haikou25.46color2三亚市Sanya68.76color4海南其它HainanQT52.50color3浙江杭州市Hangzhou22.59color2宁波市Ningbo10.41color1温州市Wenzhou65.37color4嘉兴市Jiaxing69.84color4湖州市Huzhou90.72color5绍兴市Shaoxing88.95color5金华市Jinhua32.13color2衢州市Quzhou90.56color5舟山市Zhoushan12.08color1台州市Taizhou19.31color1丽水市Lishui33.28color2江西南昌市Nanchang50.65color3萍乡市Pingxiang16.96color1新余市Xinyu24.20color2九江市Jiujiang13.30color1抚州市FuzhouJX19.37color1赣州市Ganzhou30.29color2景德镇市Jingdezhen88.53color5吉安市Jian 4.85color1上饶市Shangrao18.90color1宜春市Yichun38.66color2鹰潭市Yingtan83.72color5新疆乌鲁木齐市Urumqi87.31color5克拉玛依市Karamay26.17color2哈密地区Hami 3.83color1吐鲁番地区Turpan28.99color2博州Boertala54.02color3阿勒泰地区Aletai80.92color5塔城地区Tacheng37.51color2昌吉州Changji78.99color4伊犁州直Yili61.09color4巴州Bayinguole69.86color4阿克苏地区Akesu57.36color3克州Kezilesu46.72color3喀什地区Kashgar82.31color5和田地区Hotan 1.91color1吉林长春Changchun52.59color3吉林Jilin72.56color4通化Tonghua15.38color1四平Siping97.97color5白城Baicheng53.46color3白山Baishan94.00color5松源Songyuan98.81color5辽源Liaoyuan92.76color5延边Yanbian10.94color1安徽合肥市Hefei71.87color4芜湖市Wuhu22.84color2蚌埠市Bengbu37.42color2淮南市Huainan88.39color5马鞍山市Maanshan51.95color3淮北市Huaibei7.90color1铜陵市Tongling89.11color5安庆市Anqing65.00color4黄山市Huangshan14.39color1滁州市Chuzhou81.00color5阜阳市Fuyang60.95color4亳州市bozhou75.62color4宿州市SuzhouAH36.23color2六安市Liuan33.82color2宣城市Xuancheng74.36color4巢湖市Chaohu17.47color1池州市Chizhou81.91color5银川市Yinchuan43.40color3石嘴山市Shizuishan92.67color5吴忠市Wuzhong26.67color2固原市Guyuan32.17color2中卫市Zhongwei90.65color5凉山Liangshan67.87color4四川成都Chengdu78.73color4自贡Zigong7.51color1攀枝花Panzhihua40.86color3泸州Luzhou71.60color4德阳Deyang12.11color1绵阳Mianyang59.33color3广元Guangyuan47.47color3遂宁Suining23.24color2内江Neijiang81.71color5乐山Leshan47.69color3南充Nanchong26.64color2宜宾Yibin38.02color2广安Guangan71.00color4雅安Yaan79.64color4阿坝州Aba13.52color1甘孜州Ganzi20.40color2巴中Bazhong36.68color2眉山Meishan82.73color5资阳Ziyang53.88color3达州Dazhou 2.57color1北京Beijing57.46color3内蒙古呼和浩特市huhehaote93.57color5包头市Baotou32.49color2乌海市Wuhai78.57color4赤峰市Chifeng 3.59color1通辽市Tongliao61.02color4鄂尔多斯市Eerduosi51.98color3呼伦贝尔市Hulunbier53.62color3乌兰察布市Wulanchabu68.37color4巴彦淖尔市Bayanzhuoer 6.66color1兴安盟Xingan66.92color4锡林郭勒盟Xilinguole84.10color5阿拉善盟Alashan48.41color3河北廊坊Langfang7.32color1邢台市Xingtai76.91color4石家庄Shijiazhuang85.73color5保定市Baoding13.79color1邯郸市Handan63.87color4唐山市Tangshan26.89color2承德市Chengde7.49color1沧州市Cangzhou96.40color5张家口市Zhangjiakou7.25color1秦皇岛市Qinhuangdao57.26color3衡水市Hengshui7.15color1重庆Chongqing69.41color4上海Shanghai94.78color5宁夏西宁市Xining83.39color5海东地区Haidong27.59color2海北州Haibei64.01color4黄南州Huangnan45.26color3海南州Hainan10.82color1果洛州Guoluo30.63color2玉树州Yushu27.09color2海西州Haixi41.89color3湖南长沙市Changsha17.53color1株洲市Zhuzhou84.72color5湘潭市Xiangtan76.14color4衡阳市Hengyang48.40color3邵阳市Shaoyang45.80color3岳阳市Yueyang30.20color2常德市Changde76.44color4张家界市Zhangjiajie22.56color2益阳市Yiyang 4.71color1郴州市Chenzhou22.37color2永州市Yongzhou83.80color5怀化市Huaihua33.64color2娄底市Loudi9.88color1湘西自治州xiangxi70.51color4河南郑州市Zhengzhou39.11color2开封市Kaifeng82.19color5洛阳市Luoyang66.27color4平顶山市Pingdingshan24.69color2安阳市Anyang91.13color5鹤壁市Hebi85.29color5新乡市Xinxiang 6.09color1焦作市Jiaozuo88.94color5濮阳市Puyang91.75color5许昌市Xuchang 4.58color1漯河市Luohe64.06color4三门峡Sanmenxia66.31color4南阳市Nanyang67.90color4商丘市Shangqiu 5.70color1信阳市Xinyang 3.18color1周口市Zhoukou49.13color3驻马店市Zhumadian43.60color3济源市Jiyuan54.47color3讲师南京Nanjing7.63color1无锡Wuxi68.65color4徐州Xuzhou47.63color3常州Changzhou56.61color3苏州Suzhou30.28color2南通Nantong46.63color3连云港Lianyungang7.77color1淮安Huaian80.00color5盐城Yancheng24.11color2扬州Yangzhou84.91color5镇江Zhenjiang 4.73color1泰州TaizhouJS 5.18color1宿迁Suqian81.20color5天津Tianjin67.15color4广东广州Guangzhou59.16color3深圳Shenzhen19.21color1韶关Shaoguan24.01color2珠海Zhuhai99.39color5汕头Shantou14.14color1佛山Fuoshan97.75color5江门Jiangmen83.81color5湛江Zhanjiang98.98color5茂名Maoming73.54color4肇庆Zhaoqing21.63color2惠州Huizhou22.20color2梅州Meizhou0.77color1汕尾Shanwei74.57color4河源Heyuan50.55color3阳江Yangjiang92.92color5清远Qingyuan35.63color2东莞Dongwan86.05color5中山Zhongshan29.98color2潮州Chaozhou36.50color2揭阳Jieyang 3.89color1云浮Yunfu45.45color3山东济南市Jinan88.01color5青岛市Qingdao67.31color4淄博市Zibo41.23color3枣庄市Zaozhuang8.59color1东营市Dongying10.28color1烟台市Yantai55.22color3潍坊市Weifang89.79color5威海市Weihai92.82color5泰安市Taian78.73color4莱芜市Laiwu53.19color3济宁市Jining63.97color4临沂市Linyi38.41color2日照市Rizhao90.98color5德州市Dezhou37.17color2聊城市Liaocheng97.80color5滨州市Binzhou68.43color4菏泽市Heze17.92color1山西临汾市Linfen31.23color2晋中市Jinzhong69.22color4阳泉市Yangquan38.98color2大同市Datong71.64color4运城市Yuncheng86.43color5晋城市Jincheng71.32color4朔州市Shuozhou83.85color5吕梁市Lvliang99.39color5长治市Changzhi80.05color5忻州市Xinzhou97.36color5太原市Taiyuan55.60color3甘肃兰州市 lanzhou32.42color2嘉峪关市Jiayuguan40.51color3金昌市 Jinchang68.19color4白银市 Baiyin52.58color3天水市 Tianshui15.44color1武威市 Wuwei21.49color2张掖市 Zhangye40.04color3平凉市 Pingliang93.66color5酒泉市 Jiuquan84.10color5庆阳市 Qingyang65.07color4定西市 Dingxi80.42color5陇南市 longnan53.42color3临夏州 Linxia26.70color2甘南州 Gannan46.55color3仔细核对无误。
中国数据地图工具只要您输入各省数据，设置分档数值和填充底色，即可快[原创] ExcelPro的图表博客 红色标注标识下的填色区域为您需要填的地方。
不要修改1、输入你的数据，没有的可填0。
--->>>2、设置数据分档及图例。
--->>>安徽anhui928.79分档参考：0color1北京beijing410.46100color2重庆chongqing680.49最大值：928.79200color3福建fujian870.38最小值：64.57500color4甘肃gansu667.81800color5广东guangdong696.43广西guangxi917.86贵州guizhou169.16海南hainan750.06河北hebei703.47黑龙江heilongjiang650.15河南henan417.65湖北hubei208.84湖南hunan228.49江苏jiangsu475.02江西jiangxi474.86吉林jilin498.17辽宁liaoning620.28内蒙古neimenggu529.08宁夏ninxia816.30青海qinghai230.13山东shandong511.28上海shanghai64.57陕西shanxi3644.26山西shanxi1311.28四川sichuan526.92台湾taiwan215.50天津tianjin308.08新疆xinjiang665.59西藏xizang132.48云南yunnan265.03浙江zhejiang252.06档数值和填充底色，即可快速生成专业的中国数据地图！您需要填的地方。
不要修改其他地方，以免出现错误。
3、点击按钮开始填色。
--->>>4、OK！可以复制下面的数据地图了。
0-100100-200200-500500-800800+您可根据此文件改造出成省、市的分区数据地图！。
