您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 商业计划书 > 中国数据地图-到市级-分档填色
中国数据地图(到市级)生成模板地图绘制:郑薇Vivi。免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。模型建立:ExcelPro的图表博客、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong3.25color110~200红河州Honghe52.50color3220~4020临沧市Lincang28.17color2340~6040文山州Wenshan84.90color5460~8060昆明市Kunming42.17color3580~+80曲靖市Qujing36.28color26+玉溪市Yuxi51.77color37昭通市Shaotong81.15color58大理州Dali5.95color19楚雄州Chuxiong69.14color410普洱市Puer96.18color5保山市Baoshan53.83color3以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna81.37color5迪庆州DiqingYN42.79color3怒江州Nujiang34.26color2丽江市Lijiang92.80color5广西南宁Nanning65.61color4柳州Liuzhou57.99color3以下仅为备用百色Baise40.84color3梧州Wuzhou47.16color3钦州Qinzhou23.52color2最小值:0.66来宾Laibin73.28color4最大值:99.52崇左Chongzuo33.54color2所分档数:5桂林Guilin81.49color5间隔参考:19.77205贺州Hezhou41.32color3河池Hechi79.13color4北海Beihai69.77color4防城港Fangchenggang65.44color4贵港Guigang59.77color3玉林Yulin5.24color1黑龙江哈尔滨市Haerbin87.28color5齐齐哈尔市Qiqihaer84.94color5牡丹江市Mudanjiang34.21color2佳木斯市Jiamusi62.45color4ExcelPro的图表博客大庆市Daqing85.89color5七台河市Qitaihe63.17color4搜狐博客:绥化市Suihua56.28color3新浪微博:伊春市YichunHLJ52.57color3豆瓣读书:鸡西市Jixi32.46color2图表之道:黑河市Heihe28.99color2图表书架:鹤岗Hegang30.91color2双鸭山Shuangyashan33.61color2大兴安岭地区Daxinganling69.43color4陕西西安市Xian69.76color4铜川市Tongchuan47.04color3宝鸡市Baoji62.37color4咸阳+杨凌市Xianyang96.20color5渭南市Weinan56.42color3延安市Yanan57.85color3汉中市Hanzhong54.80color3榆林市YulinSX49.67color3安康市Ankang66.89color4商洛市Shangluo59.61color3辽宁沈阳Shenyang95.20color5大连Dalian96.10color5鞍山Anshan26.56color2抚顺Fushun6.02color1本溪Benxi2.75color1丹东Dandong39.29color2锦州Jinzhou75.43color4营口Yingkou58.72color3阜新Fuxin98.92color5辽阳Liaoyang24.78color2铁岭Tieling86.14color5朝阳Chaoyang83.39color5盘锦Panjin8.65color1葫芦岛Huludao49.32color3贵阳市Guiyang17.63color1遵义市Zunyi2.33color1安顺市Anshun39.38color2黔南州Qiannan15.16color1黔东南州Qiandongnan55.88color3铜仁地区Tongren96.08color5毕节地区Bijie21.73color2六盘水市Liupanshui77.93color4黔西南州Qianxinan29.70color2西藏拉萨市Lasa93.90color5日喀则Rikeze71.19color4昌都Changdu62.97color4林芝Linzhi7.67color1山南Shannan24.90color2阿里Ali3.98color1那曲Naqu34.01color2福建福州Fuzhou53.52color3厦门Xiamen26.39color2泉州Quanzhou58.62color3漳州Zhangzhou38.32color2莆田Putian16.63color1三明Sanming79.86color4宁德Ningde4.48color1龙岩Longyan80.25color5南平Nanping62.11color4湖北武汉市Wuhan67.09color4黄石市Huangshi85.53color5十堰市Shiyan92.56color5宜昌Yichang96.91color5襄樊市Xiangfan74.95color4鄂州Ezhou65.69color4荆门市Jingmen52.28color3孝感市Xiaogan60.75color4荆州市Jingzhou43.35color3黄冈市Huanggang78.32color4咸宁市Xianning48.90color3随州Suizhou31.11color2恩施州Enshi69.43color4神农架林区Shennongjia72.17color4天门市Tianmen18.28color1潜江Qianjiang44.78color3仙桃市Xiantao24.55color2海南海口市Haikou10.35color1三亚市Sanya12.15color1海南其它HainanQT39.09color2浙江杭州市Hangzhou81.64color5宁波市Ningbo52.09color3温州市Wenzhou4.06color1嘉兴市Jiaxing98.47color5湖州市Huzhou19.75color1绍兴市Shaoxing69.71color4金华市Jinhua9.55color1衢州市Quzhou81.29color5舟山市Zhoushan26.79color2台州市Taizhou35.65color2丽水市Lishui19.36color1江西南昌市Nanchang72.54color4萍乡市Pingxiang69.56color4新余市Xinyu22.51color2九江市Jiujiang88.54color5抚州市FuzhouJX4.50color1赣州市Ganzhou92.41color5景德镇市Jingdezhen16.39color1吉安市Jian9.26color1上饶市Shangrao51.81color3宜春市Yichun65.23color4鹰潭市Yingtan60.45color4新疆乌鲁木齐市Urumqi28.23color2克拉玛依市Karamay94.99color5哈密地区Hami12.69color1吐鲁番地区Turpan38.48color2博州Boertala28.36color2阿勒泰地区Aletai27.22color2塔城地区Tacheng2.13color1昌吉州Changji91.48color5伊犁州直Yili33.18color2巴州Bayinguole9.19color1阿克苏地区Akesu1.17color1克州Kezilesu79.48color4喀什地区Kashgar5.05color1和田地区Hotan78.31color4吉林长春Changchun64.47color4吉林Jilin76.93color4通化Tonghua62.62color4四平Siping19.68color1白城Baicheng34.09color2白山Baishan8.51color1松源Songyuan18.84color1辽源Liaoyuan10.37color1延边Yanbian32.23color2安徽合肥市Hefei30.68color2芜湖市Wuhu73.67color4蚌埠市Bengbu18.11color1淮南市Huainan71.12color4马鞍山市Maanshan42.60color3淮北市Huaibei67.90color4铜陵市Tongling86.08color5安庆市Anqing27.35color2黄山市Huangshan2.76color1滁州市Chuzhou4.31color1阜阳市Fuyang57.70color3亳州市bozhou65.45color4宿州市SuzhouAH92.71color5六安市Liuan49.79color3宣城市Xuancheng40.40color3巢湖市Chaohu37.11color2池州市Chizhou9.49color1银川市Yinchuan56.95color3石嘴山市Shizuishan49.30color3吴忠市Wuzhong59.26color3固原市Guyuan60.17color4中卫市Zhongwei81.62color5凉山Liangshan78.90color4四川成都Chengdu59.39color3自贡Zigong37.82color2攀枝花Panzhihua34.30color2泸州Luzhou59.39color3德阳Deyang71.94color4绵阳Mianyang29.18color2广元Guangyuan79.17color4遂宁Suining2.61color1内江Neijiang34.32color2乐山Leshan2.06color1南充Nanchong65.93color4宜宾Yibin94.21color5广安Guangan25.71color2雅安Yaan9.07color1阿坝州Aba35.94color2甘孜州Ganzi0.66color1巴中Bazhong60.75color4眉山Meishan62.34color4资阳Ziyang17.79color1达州Dazhou52.73color3北京Beijing44.09color3内蒙古呼和浩特市huhehaote99.35color5包头市Baotou78.88color4乌海市Wuhai99.52color5赤峰市Chifeng93.03color5通辽市Tongliao36.10color2鄂尔多斯市Eerduosi60.58color4呼伦贝尔市Hulunbier18.65color1乌兰察布市Wulanchabu49.22color3巴彦淖尔市Bayanzhuoer71.26color4兴安盟Xingan45.09color3锡林郭勒盟Xilinguole71.55color4阿拉善盟Alashan11.10color1河北廊坊Langfang46.10color3邢台市Xingtai98.59color5石家庄Shijiazhuang32.85color2保定市Baoding25.63color2邯郸市Handan77.51color4唐山市Tangshan34.05color2承德市Chengde94.67color5沧州市Cangzhou38.07color2张家口市Zhangjiakou25.46color2秦皇岛市Qinhuangdao7.10color1衡水市Hengshui46.4
本文标题:中国数据地图-到市级-分档填色
链接地址:https://www.777doc.com/doc-1781081 .html