中国数据地图-到市级-分档填色表格文件下载.xls

中国数据地图-到市级-分档填色表格文件下载.xls

《中国数据地图-到市级-分档填色表格文件下载.xls》由会员分享，可在线阅读，更多相关《中国数据地图-到市级-分档填色表格文件下载.xls（32页珍藏版）》请在冰豆网上搜索。

免责声明：

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

模型建立：

ExcelPro的图表博客http:

/ExcelP2010.11.61、填入数据：

2、设置图例：

3、设置阀值：

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

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

填色：

云南德宏州Dehong47.01color310200红河州Honghe87.13color52204020临沧市Lincang35.26color23406040文山州Wenshan15.24color14608060昆明市Kunming97.75color5580+80曲靖市Qujing8.49color16+玉溪市Yuxi74.74color47昭通市Shaotong68.76color48大理州Dali4.17color19楚雄州Chuxiong54.56color310普洱市Puer72.05color4保山市Baoshan97.81color5以上预留了5个分档的位置，若需要可往下添加版纳州Xishuangbanna10.10color1迪庆州DiqingYN43.00color3怒江州Nujiang34.08color2丽江市Lijiang15.49color1广西南宁Nanning59.87color3柳州Liuzhou17.31color1以下仅为备用百色Baise91.87color5梧州Wuzhou52.52color3钦州Qinzhou20.70color2最小值：

0.40来宾Laibin60.75color4最大值：

99.97崇左Chongzuo13.19color1所分档数：

5桂林Guilin51.82color3间隔参考：

19.91583贺州Hezhou7.57color1河池Hechi30.99color2北海Beihai86.98color5防城港Fangchenggang33.24color2贵港Guigang39.26color2玉林Yulin0.64color1黑龙江哈尔滨市Haerbin68.14color4齐齐哈尔市Qiqihaer19.45color1牡丹江市Mudanjiang94.10color5佳木斯市Jiamusi72.59color4ExcelPro的的图图表表博博客客大庆市Daqing78.26color4七台河市Qitaihe60.95color4搜狐博客：

绥化市Suihua45.34color3新浪微博：

伊春市YichunHLJ39.77color2豆瓣读书：

鸡西市Jixi14.81color1图表之道：

黑河市Heihe1.01color1图表书架：

鹤岗Hegang20.23color2双鸭山Shuangyashan52.31color3大兴安岭地区Daxinganling75.97color4陕西西安市Xian26.93color2铜川市Tongchuan24.79color2宝鸡市Baoji85.20color5咸阳+杨凌市Xianyang44.09color3渭南市Weinan53.31color3延安市Yanan0.40color1汉中市Hanzhong51.05color3榆林市YulinSX26.48color2安康市Ankang94.24color5商洛市Shangluo78.22color4辽宁沈阳Shenyang47.36color3大连Dalian72.40color4鞍山Anshan44.42color3抚顺Fushun61.87color4本溪Benxi94.47color5丹东Dandong73.87color4锦州Jinzhou76.24color4营口Yingkou6.28color1阜新Fuxin40.59color3辽阳Liaoyang49.96color3铁岭Tieling86.39color5朝阳Chaoyang18.61color1盘锦Panjin66.58color4葫芦岛Huludao24.09color2贵阳市Guiyang92.90color5遵义市Zunyi77.13color4安顺市Anshun93.03color5黔南州Qiannan30.34color2黔东南州Qiandongnan71.83color4铜仁地区Tongren75.03color4毕节地区Bijie84.69color5六盘水市Liupanshui7.18color1黔西南州Qianxinan37.43color2西藏拉萨市Lasa62.46color4日喀则Rikeze91.86color5昌都Changdu51.45color3林芝Linzhi7.83color1山南Shannan49.03color3阿里Ali59.65color3那曲Naqu94.65color5福建福州Fuzhou75.45color4厦门Xiamen64.32color4泉州Quanzhou75.53color4漳州Zhangzhou94.85color5莆田Putian50.32color3三明Sanming3.40color1宁德Ningde94.68color5龙岩Longyan58.11color3南平Nanping64.05color4湖北武汉市Wuhan9.94color1黄石市Huangshi78.59color4十堰市Shiyan4.66color1宜昌Yichang25.03color2襄樊市Xiangfan68.37color4鄂州Ezhou61.90color4荆门市Jingmen95.54color5孝感市Xiaogan31.64color2荆州市Jingzhou81.66color5黄冈市Huanggang74.62color4咸宁市Xianning71.59color4随州Suizhou82.10color5恩施州Enshi23.82color2神农架林区Shennongjia24.83color2天门市Tianmen78.71color4潜江Qianjiang16.06color1仙桃市Xiantao49.94color3海南海口市Haikou99.97color5三亚市Sanya13.11color1海南其它HainanQT47.32color3浙江杭州市Hangzhou34.80color2宁波市Ningbo92.93color5温州市Wenzhou55.56color3嘉兴市Jiaxing55.62color3湖州市Huzhou39.95color2绍兴市Shaoxing42.94color3金华市Jinhua72.70color4衢州市Quzhou64.78color4舟山市Zhoushan31.33color2台州市Taizhou22.91color2丽水市Lishui53.24color3江西南昌市Nanchang82.03color5萍乡市Pingxiang51.42color3新余市Xinyu43.08color3九江市Jiujiang62.79color4抚州市FuzhouJX97.61color5赣州市Ganzhou0.56color1景德镇市Jingdezhen31.91color2吉安市Jian52.18color3上饶市Shangrao39.12color2宜春市Yichun88.61color5鹰潭市Yingtan0.51color1新疆乌鲁木齐市Urumqi40.28color3克拉玛依市Karamay92.89color5哈密地区Hami20.34color2吐鲁番地区Turpan14.61color1博州Boertala47.26color3阿勒泰地区Aletai80.53color5塔城地区Tacheng26.77color2昌吉州Changji88.70color5伊犁州直Yili68.17color4巴州Bayinguole72.33color4阿克苏地区Akesu8.88color1克州Kezilesu60.07color4喀什地区Kashgar57.68color3和田地区Hotan90.12color5吉林长春Changchun5.00color1吉林Jilin32.87color2通化Tonghua15.06color1四平Siping67.12color4白城Baicheng44.98color3白山Baishan65.80color4松源Songyuan87.10color5辽源Liaoyuan18.99color1延边Yanbian13.55color1安徽合肥市Hefei6.00color1芜湖市Wuhu74.28color4蚌埠市Bengbu69.48color4淮南市Huainan38.86color2马鞍山市Maanshan4.07color1淮北市Huaibei82.84color5铜陵市Tongling29.37color2安庆市Anqing52.86color3黄山市Huangshan38.17color2滁州市Chuzhou11.10color1阜阳市Fuyang0.82color1亳州市bozhou43.66color3宿州市SuzhouAH12.49color1六安市Liuan59.87color3宣城市Xuancheng8.09color1巢湖市Chaohu8.86color1池州市Chizhou10.86color1银川市Yinchuan90.47color5石嘴山市Shizuishan74.18color4吴忠市Wuzhong35.75color2固原市Guyuan32.70color2中卫市Zhongwei37.41color2凉山Liangshan18.30color1四川成都Chengdu68.27color4自贡Zigong26.21color2攀枝花Panzhihua53.04color3泸州Luzhou23.78color2德阳Deyang39.73color2绵阳Mianyang58.11color3广元Guangyuan60.44color4遂宁Suining1.90color1内江Neijiang78.95color4乐山Leshan47.46color3南充Nanchong91.73color5宜宾Yibin7.94color1广安Guangan37.54color2雅安Yaan24.56color2阿坝州Aba38.75color2甘孜州Ganzi79.94color4巴中Bazhong5.15color1眉山Meishan17.29color1资阳Ziyang78.10color4达州Dazhou13.96color1北京Beijing90.76color5内蒙古呼和浩特市huhehaote97.49color5包头市Baotou63.34color4乌海市Wuhai18.83color1赤峰市Chifeng46.08color3通辽市Tongliao2.89color1鄂尔多斯市Eerduosi53.48color3呼伦贝尔市Hulunbier43.74color3乌兰察布市Wulanchabu11.04color1巴彦淖尔市Bayanzhuoer39.24color2兴安盟Xingan30.06color2锡林郭勒盟Xilinguole8.68color1阿拉善盟Alashan36.06color2河北廊坊Langfang44.81color3邢台市Xingtai26.42c