中国数据地图-到市级-分档填色

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

中国数据地图(到市级)生成模板地图绘制:郑薇Vivi。免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。模型建立:ExcelPro的图表博客、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong52.77color310~200红河州Honghe67.54color4220~4020临沧市Lincang9.21color1340~6040文山州Wenshan19.52color1460~8060昆明市Kunming81.08color5580~+80曲靖市Qujing55.76color36+玉溪市Yuxi71.23color47昭通市Shaotong21.58color28大理州Dali98.65color59楚雄州Chuxiong7.98color110普洱市Puer52.32color3保山市Baoshan22.26color2以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna15.49color1迪庆州DiqingYN55.78color3怒江州Nujiang9.97color1丽江市Lijiang15.38color1广西南宁Nanning58.57color3柳州Liuzhou43.53color3以下仅为备用百色Baise8.40color1梧州Wuzhou13.95color1钦州Qinzhou99.41color5最小值:0.66来宾Laibin48.49color3最大值:99.89崇左Chongzuo29.57color2所分档数:5桂林Guilin72.83color4间隔参考:19.84643贺州Hezhou9.73color1河池Hechi65.31color4北海Beihai94.84color5防城港Fangchenggang32.54color2贵港Guigang9.23color1玉林Yulin65.55color4黑龙江哈尔滨市Haerbin10.80color1齐齐哈尔市Qiqihaer40.89color3牡丹江市Mudanjiang9.16color1佳木斯市Jiamusi82.48color5ExcelPro的图表博客大庆市Daqing44.16color3七台河市Qitaihe90.23color5搜狐博客:绥化市Suihua29.05color2新浪微博:伊春市YichunHLJ77.87color4豆瓣读书:鸡西市Jixi86.96color5图表之道:黑河市Heihe19.24color1图表书架:鹤岗Hegang14.65color1双鸭山Shuangyashan4.60color1大兴安岭地区Daxinganling72.25color4陕西西安市Xian97.45color5铜川市Tongchuan93.92color5宝鸡市Baoji65.07color4咸阳+杨凌市Xianyang25.61color2渭南市Weinan9.54color1延安市Yanan50.41color3汉中市Hanzhong97.09color5榆林市YulinSX97.93color5安康市Ankang9.90color1商洛市Shangluo29.93color2辽宁沈阳Shenyang59.34color3大连Dalian26.80color2鞍山Anshan62.62color4抚顺Fushun23.67color2本溪Benxi23.12color2丹东Dandong77.60color4锦州Jinzhou14.41color1营口Yingkou53.84color3阜新Fuxin43.30color3辽阳Liaoyang73.04color4铁岭Tieling10.35color1朝阳Chaoyang33.27color2盘锦Panjin7.66color1葫芦岛Huludao6.21color1贵阳市Guiyang75.88color4遵义市Zunyi57.04color3安顺市Anshun63.87color4黔南州Qiannan10.70color1黔东南州Qiandongnan19.56color1铜仁地区Tongren22.34color2毕节地区Bijie83.13color5六盘水市Liupanshui93.24color5黔西南州Qianxinan57.83color3西藏拉萨市Lasa46.85color3日喀则Rikeze29.36color2昌都Changdu93.63color5林芝Linzhi17.56color1山南Shannan9.61color1阿里Ali49.24color3那曲Naqu40.57color3福建福州Fuzhou41.64color3厦门Xiamen68.59color4泉州Quanzhou89.27color5漳州Zhangzhou55.79color3莆田Putian99.83color5三明Sanming73.08color4宁德Ningde81.83color5龙岩Longyan59.86color3南平Nanping33.91color2湖北武汉市Wuhan32.77color2黄石市Huangshi47.23color3十堰市Shiyan53.01color3宜昌Yichang93.11color5襄樊市Xiangfan57.03color3鄂州Ezhou50.03color3荆门市Jingmen85.63color5孝感市Xiaogan28.77color2荆州市Jingzhou41.68color3黄冈市Huanggang48.52color3咸宁市Xianning99.89color5随州Suizhou12.43color1恩施州Enshi54.05color3神农架林区Shennongjia88.62color5天门市Tianmen82.38color5潜江Qianjiang49.48color3仙桃市Xiantao53.09color3海南海口市Haikou98.76color5三亚市Sanya31.64color2海南其它HainanQT30.23color2浙江杭州市Hangzhou56.47color3宁波市Ningbo71.75color4温州市Wenzhou11.08color1嘉兴市Jiaxing85.89color5湖州市Huzhou32.59color2绍兴市Shaoxing62.26color4金华市Jinhua23.79color2衢州市Quzhou50.67color3舟山市Zhoushan24.21color2台州市Taizhou32.78color2丽水市Lishui91.83color5江西南昌市Nanchang16.97color1萍乡市Pingxiang12.54color1新余市Xinyu15.91color1九江市Jiujiang21.93color2抚州市FuzhouJX63.98color4赣州市Ganzhou57.47color3景德镇市Jingdezhen45.24color3吉安市Jian46.59color3上饶市Shangrao17.05color1宜春市Yichun63.23color4鹰潭市Yingtan55.55color3新疆乌鲁木齐市Urumqi81.55color5克拉玛依市Karamay92.43color5哈密地区Hami71.98color4吐鲁番地区Turpan47.44color3博州Boertala52.01color3阿勒泰地区Aletai20.89color2塔城地区Tacheng3.27color1昌吉州Changji18.93color1伊犁州直Yili27.51color2巴州Bayinguole98.35color5阿克苏地区Akesu94.32color5克州Kezilesu92.16color5喀什地区Kashgar57.14color3和田地区Hotan98.61color5吉林长春Changchun90.63color5吉林Jilin75.63color4通化Tonghua78.49color4四平Siping65.87color4白城Baicheng36.28color2白山Baishan55.80color3松源Songyuan15.24color1辽源Liaoyuan75.19color4延边Yanbian58.57color3安徽合肥市Hefei20.77color2芜湖市Wuhu40.57color3蚌埠市Bengbu63.82color4淮南市Huainan33.78color2马鞍山市Maanshan27.08color2淮北市Huaibei80.80color5铜陵市Tongling41.66color3安庆市Anqing88.91color5黄山市Huangshan74.68color4滁州市Chuzhou64.22color4阜阳市Fuyang63.99color4亳州市bozhou15.05color1宿州市SuzhouAH60.34color4六安市Liuan73.98color4宣城市Xuancheng14.57color1巢湖市Chaohu80.37color5池州市Chizhou14.56color1银川市Yinchuan63.48color4石嘴山市Shizuishan72.25color4吴忠市Wuzhong5.31color1固原市Guyuan91.68color5中卫市Zhongwei53.94color3凉山Liangshan9.75color1四川成都Chengdu37.49color2自贡Zigong36.40color2攀枝花Panzhihua81.00color5泸州Luzhou86.05color5德阳Deyang36.57color2绵阳Mianyang97.17color5广元Guangyuan21.50color2遂宁Suining94.60color5内江Neijiang79.74color4乐山Leshan16.11color1南充Nanchong66.67color4宜宾Yibin59.71color3广安Guangan32.91color2雅安Yaan41.46color3阿坝州Aba58.78color3甘孜州Ganzi56.16color3巴中Bazhong50.90color3眉山Meishan49.89color3资阳Ziyang4.04color1达州Dazhou65.08color4北京Beijing19.13color1内蒙古呼和浩特市huhehaote12.29color1包头市Baotou26.66color2乌海市Wuhai75.15color4赤峰市Chifeng14.82color1通辽市Tongliao6.47color1鄂尔多斯市Eerduosi61.15color4呼伦贝尔市Hulunbier34.21color2乌兰察布市Wulanchabu15.92color1巴彦淖尔市Bayanzhuoer65.36color4兴安盟Xingan46.93color3锡林郭勒盟Xilinguole75.40color4阿拉善盟Alashan7.89color1河北廊坊Langfang46.65color3邢台市Xingtai31.28color2石家庄Shijiazhuang72.03color4保定市Baoding72.42color4邯郸市Handan26.75color2唐山市Tangshan27.31color2承德市Chengde60.66color4沧州市Cangzhou68.90color4张家口市Zhangjiakou94.55color5秦皇岛市Qinhuangdao18.40color1衡水市Heng

1 / 32
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功