您好,欢迎访问三七文档
当前位置:首页 > 商业/管理/HR > 商业计划书 > 中国数据地图(热力图)-到市级-分档填色
中国数据地图(到市级)生成模板地图绘制:郑薇Vivi。免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。模型建立:ExcelPro的图表博客、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong32.25color210~200红河州Honghe47.05color3220~4020临沧市Lincang9.10color1340~6040文山州Wenshan70.83color4460~8060昆明市Kunming15.12color1580~+80曲靖市Qujing0.87color16+玉溪市Yuxi86.91color57昭通市Shaotong12.96color18大理州Dali29.41color29楚雄州Chuxiong78.03color410普洱市Puer94.19color5保山市Baoshan0.28color1以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna9.30color1迪庆州DiqingYN40.41color3怒江州Nujiang59.49color3丽江市Lijiang38.76color2广西南宁Nanning64.32color4柳州Liuzhou37.79color2以下仅为备用百色Baise79.66color4梧州Wuzhou91.84color5钦州Qinzhou33.77color2最小值:0.28来宾Laibin71.70color4最大值:99.87崇左Chongzuo84.07color5所分档数:5桂林Guilin36.78color2间隔参考:19.91665贺州Hezhou87.76color5河池Hechi35.88color2北海Beihai28.49color2防城港Fangchenggang31.63color2贵港Guigang21.51color2玉林Yulin69.00color4黑龙江哈尔滨市Haerbin43.62color3齐齐哈尔市Qiqihaer64.67color4牡丹江市Mudanjiang70.22color4佳木斯市Jiamusi55.57color3ExcelPro的图表博客大庆市Daqing84.87color5七台河市Qitaihe23.05color2搜狐博客:绥化市Suihua64.70color4新浪微博:伊春市YichunHLJ65.34color4豆瓣读书:鸡西市Jixi26.59color2图表之道:黑河市Heihe53.14color3图表书架:鹤岗Hegang77.12color4双鸭山Shuangyashan66.06color4大兴安岭地区Daxinganling67.44color4陕西西安市Xian18.80color1铜川市Tongchuan27.09color2宝鸡市Baoji34.56color2咸阳+杨凌市Xianyang12.97color1渭南市Weinan12.20color1延安市Yanan18.57color1汉中市Hanzhong50.12color3榆林市YulinSX77.33color4安康市Ankang64.27color4商洛市Shangluo67.47color4辽宁沈阳Shenyang21.49color2大连Dalian66.61color4鞍山Anshan44.00color3抚顺Fushun73.61color4本溪Benxi90.52color5丹东Dandong19.42color1锦州Jinzhou31.02color2营口Yingkou84.10color5阜新Fuxin58.06color3辽阳Liaoyang0.42color1铁岭Tieling1.94color1朝阳Chaoyang20.99color2盘锦Panjin77.32color4葫芦岛Huludao17.81color1贵阳市Guiyang54.31color3遵义市Zunyi60.27color4安顺市Anshun98.50color5黔南州Qiannan20.05color2黔东南州Qiandongnan90.06color5铜仁地区Tongren52.71color3毕节地区Bijie67.63color4六盘水市Liupanshui63.72color4黔西南州Qianxinan80.38color5西藏拉萨市Lasa32.49color2日喀则Rikeze3.01color1昌都Changdu43.99color3林芝Linzhi13.27color1山南Shannan54.46color3阿里Ali39.15color2那曲Naqu93.48color5福建福州Fuzhou96.49color5厦门Xiamen33.62color2泉州Quanzhou86.21color5漳州Zhangzhou67.22color4莆田Putian62.90color4三明Sanming8.01color1宁德Ningde36.32color2龙岩Longyan52.36color3南平Nanping57.69color3湖北武汉市Wuhan99.87color5黄石市Huangshi99.73color5十堰市Shiyan27.31color2宜昌Yichang73.93color4襄樊市Xiangfan78.39color4鄂州Ezhou82.91color5荆门市Jingmen73.69color4孝感市Xiaogan50.91color3荆州市Jingzhou8.97color1黄冈市Huanggang60.79color4咸宁市Xianning7.93color1随州Suizhou56.64color3恩施州Enshi70.72color4神农架林区Shennongjia92.63color5天门市Tianmen89.43color5潜江Qianjiang81.68color5仙桃市Xiantao3.45color1海南海口市Haikou63.17color4三亚市Sanya97.96color5海南其它HainanQT75.52color4浙江杭州市Hangzhou93.59color5宁波市Ningbo1.68color1温州市Wenzhou24.68color2嘉兴市Jiaxing3.43color1湖州市Huzhou69.15color4绍兴市Shaoxing20.34color2金华市Jinhua32.77color2衢州市Quzhou51.83color3舟山市Zhoushan15.22color1台州市Taizhou74.07color4丽水市Lishui72.70color4江西南昌市Nanchang84.00color5萍乡市Pingxiang81.10color5新余市Xinyu50.39color3九江市Jiujiang64.58color4抚州市FuzhouJX82.91color5赣州市Ganzhou99.56color5景德镇市Jingdezhen50.86color3吉安市Jian72.96color4上饶市Shangrao97.10color5宜春市Yichun0.33color1鹰潭市Yingtan89.51color5新疆乌鲁木齐市Urumqi44.94color3克拉玛依市Karamay87.70color5哈密地区Hami45.21color3吐鲁番地区Turpan29.59color2博州Boertala51.38color3阿勒泰地区Aletai67.62color4塔城地区Tacheng54.72color3昌吉州Changji91.74color5伊犁州直Yili57.36color3巴州Bayinguole91.61color5阿克苏地区Akesu51.33color3克州Kezilesu86.19color5喀什地区Kashgar51.56color3和田地区Hotan20.26color2吉林长春Changchun69.73color4吉林Jilin57.73color3通化Tonghua40.83color3四平Siping19.07color1白城Baicheng79.88color4白山Baishan51.96color3松源Songyuan77.62color4辽源Liaoyuan86.57color5延边Yanbian22.52color2安徽合肥市Hefei64.52color4芜湖市Wuhu11.83color1蚌埠市Bengbu94.73color5淮南市Huainan73.89color4马鞍山市Maanshan67.36color4淮北市Huaibei42.94color3铜陵市Tongling64.27color4安庆市Anqing25.96color2黄山市Huangshan97.15color5滁州市Chuzhou82.62color5阜阳市Fuyang42.96color3亳州市bozhou92.28color5宿州市SuzhouAH90.51color5六安市Liuan51.21color3宣城市Xuancheng42.41color3巢湖市Chaohu1.68color1池州市Chizhou70.54color4银川市Yinchuan26.74color2石嘴山市Shizuishan66.51color4吴忠市Wuzhong9.88color1固原市Guyuan42.13color3中卫市Zhongwei76.51color4凉山Liangshan66.71color4四川成都Chengdu37.40color2自贡Zigong41.62color3攀枝花Panzhihua18.00color1泸州Luzhou32.58color2德阳Deyang17.15color1绵阳Mianyang14.05color1广元Guangyuan95.71color5遂宁Suining7.24color1内江Neijiang58.40color3乐山Leshan41.35color3南充Nanchong68.24color4宜宾Yibin72.23color4广安Guangan44.94color3雅安Yaan91.04color5阿坝州Aba21.57color2甘孜州Ganzi36.33color2巴中Bazhong74.90color4眉山Meishan62.59color4资阳Ziyang24.75color2达州Dazhou97.63color5北京Beijing84.23color5内蒙古呼和浩特市huhehaote53.38color3包头市Baotou21.48color2乌海市Wuhai72.99color4赤峰市Chifeng39.16color2通辽市Tongliao62.75color4鄂尔多斯市Eerduosi10.53color1呼伦贝尔市Hulunbier21.87color2乌兰察布市Wulanchabu95.32color5巴彦淖尔市Bayanzhuoer98.31color5兴安盟Xingan13.70color1锡林郭勒盟Xilinguole35.42color2阿拉善盟Alashan81.62color5河北廊坊Langfang27.39color2邢台市Xingtai72.75color4石家庄Shijiazhuang13.08color1保定市Baoding22.48color2邯郸市Handan68.66color4唐山市Tangshan13.86color1承德市Chengde91.82color5沧州市Cangzhou56.04color3张家口市Zhangjiakou51.48color3秦皇岛市Qinhuangdao22.43color2衡水市He
本文标题:中国数据地图(热力图)-到市级-分档填色
链接地址:https://www.777doc.com/doc-4690710 .html