创意图表-地图(可填色)
- 格式:doc
- 大小:157.00 KB
- 文档页数:2
中国数据地图(到市级)生成模板地图绘制:郑薇 Vivi。
免责声明:并不保证地市图形完全对应准确,商用请自行仔细核对无误。
模型建立:ExcelPro的图表博客2010.11.61、填入数据:2、设置图例:3、设置阀值:在D列填入/粘贴数值G11:H15将被作为图例输入分档的下限值数值:填色:云南德宏州Dehong0.00color10红河州Honghe0.00color120临沧市Lincang0.00color140文山州Wenshan0.00color160昆明市Kunming0.00color180曲靖市Qujing0.00color1+玉溪市Yuxi0.00color17昭通市Shaotong0.00color18大理州Dali0.00color19楚雄州Chuxiong0.00color110普洱市Puer0.00color1保山市Baoshan0.00color1以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangban0.00color1迪庆州DiqingYN0.00color1怒江州Nujiang0.00color1丽江市Lijiang0.00color1广西南宁Nanning40.00color3柳州Liuzhou40.00color3以下仅为备用百色Baise0.00color1梧州Wuzhou0.00color1钦州Qinzhou0.00color1最小值:0.00来宾Laibin0.00color1最大值:40.00崇左Chongzuo0.00color1所分档数:5桂林Guilin40.00color3间隔参考:8贺州Hezhou0.00color1河池Hechi0.00color1北海Beihai0.00color1防城港Fangchengga0.00color1贵港Guigang0.00color1玉林Yulin0.00color1黑龙江哈尔滨市Haerbin0.00color1齐齐哈尔市Qiqihaer0.00color1牡丹江市Mudanjiang0.00color1佳木斯市Jiamusi0.00color1ExcelPro的图表博客大庆市Daqing0.00color1七台河市Qitaihe0.00color1搜狐博客:绥化市Suihua0.00color1新浪微博:伊春市YichunHLJ0.00color1豆瓣读书:鸡西市Jixi0.00color1图表之道:黑河市Heihe0.00color1图表书架:鹤岗Hegang0.00color1双鸭山Shuangyasha0.00color1大兴安岭地区D axinganling0.00color1陕西西安市Xian0.00color1铜川市Tongchuan0.00color1宝鸡市Baoji0.00color1咸阳+杨凌市Xianyang0.00color1渭南市Weinan0.00color1延安市Yanan0.00color1汉中市Hanzhong0.00color1榆林市YulinSX0.00color1安康市Ankang0.00color1商洛市Shangluo0.00color1辽宁沈阳Shenyang40.00color3大连Dalian40.00color3鞍山Anshan40.00color3抚顺Fushun0.00color1本溪Benxi40.00color3丹东Dandong0.00color1锦州Jinzhou0.00color1营口Yingkou0.00color1阜新Fuxin0.00color1辽阳Liaoyang0.00color1铁岭Tieling40.00color3朝阳Chaoyang0.00color1盘锦Panjin0.00color1葫芦岛Huludao0.00color1贵州贵阳市Guiyang40.00color3遵义市Zunyi0.00color1安顺市Anshun0.00color1黔南州Qiannan0.00color1黔东南州Qiandongnan0.00color1铜仁地区Tongren0.00color1毕节地区Bijie0.00color1六盘水市Liupanshui0.00color1黔西南州Qianxinan0.00color1西藏拉萨市Lasa0.00color1日喀则Rikeze0.00color1昌都Changdu0.00color1林芝Linzhi0.00color1山南Shannan0.00color1阿里Ali0.00color1那曲Naqu0.00color1福建福州Fuzhou40.00color3厦门Xiamen0.00color1泉州Quanzhou0.00color1漳州Zhangzhou0.00color1莆田Putian0.00color1三明Sanming0.00color1宁德Ningde0.00color1龙岩Longyan0.00color1南平Nanping0.00color1湖北武汉市Wuhan0.00color1黄石市Huangshi0.00color1十堰市Shiyan0.00color1宜昌Yichang40.00color3襄樊市Xiangfan0.00color1鄂州Ezhou0.00color1荆门市Jingmen0.00color1孝感市Xiaogan0.00color1荆州市Jingzhou0.00color1黄冈市Huanggang0.00color1咸宁市Xianning0.00color1随州Suizhou0.00color1恩施州Enshi0.00color1神农架林区Shennongjia0.00color1天门市Tianmen0.00color1潜江Qianjiang0.00color1仙桃市Xiantao0.00color1海南海口市Haikou40.00color3三亚市Sanya0.00color1海南其它HainanQT0.00color1浙江杭州市Hangzhou40.00color3宁波市Ningbo40.00color3温州市Wenzhou40.00color3嘉兴市Jiaxing0.00color1湖州市Huzhou40.00color3绍兴市Shaoxing40.00color3金华市Jinhua40.00color3衢州市Quzhou0.00color1舟山市Zhoushan0.00color1台州市Taizhou40.00color3丽水市Lishui0.00color1江西南昌市Nanchang0.00color1萍乡市Pingxiang0.00color1新余市Xinyu40.00color3九江市Jiujiang40.00color3抚州市FuzhouJX0.00color1赣州市Ganzhou40.00color3景德镇市Jingdezhen0.00color1吉安市Jian0.00color1上饶市Shangrao40.00color3宜春市Yichun0.00color1鹰潭市Yingtan0.00color1新疆乌鲁木齐市Urumqi40.00color3克拉玛依市Karamay0.00color1哈密地区Hami0.00color1吐鲁番地区Turpan0.00color1博州Boertala0.00color1阿勒泰地区Aletai0.00color1塔城地区Tacheng0.00color1昌吉州Changji0.00color1伊犁州直Yili0.00color1巴州Bayinguole0.00color1阿克苏地区Akesu0.00color1克州Kezilesu0.00color1喀什地区Kashgar0.00color1和田地区Hotan0.00color1吉林长春Changchun40.00color3吉林Jilin0.00color1通化Tonghua0.00color1四平Siping0.00color1白城Baicheng0.00color1白山Baishan0.00color1松源Songyuan0.00color1辽源Liaoyuan0.00color1延边Yanbian0.00color1安徽合肥市Hefei40.00color3芜湖市Wuhu0.00color1蚌埠市Bengbu0.00color1淮南市Huainan0.00color1马鞍山市Maanshan0.00color1淮北市Huaibei0.00color1铜陵市Tongling0.00color1安庆市Anqing0.00color1黄山市Huangshan0.00color1滁州市Chuzhou0.00color1阜阳市Fuyang0.00color1亳州市bozhou0.00color1宿州市SuzhouAH0.00color1六安市Liuan0.00color1宣城市Xuancheng0.00color1巢湖市Chaohu0.00color1池州市Chizhou0.00color1宁夏银川市Yinchuan0.00color1石嘴山市Shizuishan0.00color1吴忠市Wuzhong0.00color1固原市Guyuan0.00color1中卫市Zhongwei0.00color1凉山Liangshan0.00color1四川成都Chengdu40.00color3自贡Zigong0.00color1攀枝花Panzhihua0.00color1泸州Luzhou0.00color1德阳Deyang0.00color1绵阳Mianyang0.00color1广元Guangyuan0.00color1遂宁Suining0.00color1内江Neijiang0.00color1乐山Leshan0.00color1南充Nanchong0.00color1宜宾Yibin0.00color1广安Guangan0.00color1雅安Yaan0.00color1阿坝州Aba0.00color1甘孜州Ganzi0.00color1巴中Bazhong0.00color1眉山Meishan0.00color1资阳Ziyang0.00color1达州Dazhou0.00color1北京Beijing40.00color3内蒙古呼和浩特市huhehaote0.00color1包头市Baotou0.00color1乌海市Wuhai0.00color1赤峰市Chifeng0.00color1通辽市Tongliao0.00color1鄂尔多斯市Eerduosi0.00color1呼伦贝尔市Hulunbier0.00color1乌兰察布市Wulanchabu0.00color1巴彦淖尔市Bayanzhuoer0.00color1兴安盟Xingan0.00color1锡林郭勒盟Xilinguole0.00color1阿拉善盟Alashan0.00color1河北廊坊Langfang0.00color1邢台市Xingtai40.00color3石家庄Shijiazhuang40.00color3保定市Baoding40.00color3邯郸市Handan0.00color1唐山市Tangshan40.00color3承德市Chengde0.00color1沧州市Cangzhou0.00color1张家口市Zhangjiakou0.00color1秦皇岛市Qinhuangdao0.00color1衡水市Hengshui0.00color1重庆Chongqing40.00color3上海Shanghai40.00color3青海西宁市Xining40.00color3海东地区Haidong0.00color1海北州Haibei0.00color1黄南州Huangnan0.00color1海南州Hainan0.00color1果洛州Guoluo0.00color1玉树州Yushu0.00color1海西州Haixi0.00color1湖南长沙市Changsha40.00color3株洲市Zhuzhou0.00color1湘潭市Xiangtan40.00color3衡阳市Hengyang0.00color1邵阳市Shaoyang0.00color1岳阳市Yueyang0.00color1常德市Changde40.00color3张家界市Zhangjiajie0.00color1益阳市Yiyang40.00color3郴州市Chenzhou40.00color3永州市Yongzhou0.00color1怀化市Huaihua40.00color3娄底市Loudi40.00color3湘西自治州xiangxi0.00color1河南郑州市Zhengzhou0.00color1开封市Kaifeng0.00color1洛阳市Luoyang0.00color1平顶山市Pingdingshan0.00color1安阳市Anyang0.00color1鹤壁市Hebi0.00color1新乡市Xinxiang0.00color1焦作市Jiaozuo0.00color1濮阳市Puyang0.00color1许昌市Xuchang0.00color1漯河市Luohe0.00color1三门峡Sanmenxia0.00color1南阳市Nanyang0.00color1商丘市Shangqiu0.00color1信阳市Xinyang0.00color1周口市Zhoukou0.00color1驻马店市Zhumadian0.00color1济源市Jiyuan0.00color1江苏南京Nanjing40.00color3无锡Wuxi40.00color3徐州Xuzhou40.00color3常州Changzhou0.00color1苏州Suzhou40.00color3南通Nantong0.00color1连云港Lianyungang0.00color1淮安Huaian0.00color1盐城Yancheng0.00color1扬州Yangzhou0.00color1镇江Zhenjiang0.00color1泰州TaizhouJS0.00color1宿迁Suqian0.00color1天津Tianjin0.00color1广东广州Guangzhou40.00color3深圳Shenzhen40.00color3韶关Shaoguan0.00color1珠海Zhuhai40.00color3汕头Shantou40.00color3佛山Fuoshan0.00color1江门Jiangmen40.00color3湛江Zhanjiang40.00color3茂名Maoming0.00color1肇庆Zhaoqing0.00color1惠州Huizhou0.00color1梅州Meizhou0.00color1汕尾Shanwei0.00color1河源Heyuan0.00color1阳江Yangjiang0.00color1清远Qingyuan40.00color3东莞Dongwan40.00color3中山Zhongshan40.00color3潮州Chaozhou0.00color1揭阳Jieyang0.00color1云浮Yunfu0.00color1山东济南市Jinan40.00color3青岛市Qingdao40.00color3淄博市Zibo0.00color1枣庄市Zaozhuang0.00color1东营市Dongying0.00color1烟台市Yantai0.00color1潍坊市Weifang0.00color1威海市Weihai0.00color1泰安市Taian0.00color1莱芜市Laiwu0.00color1济宁市Jining0.00color1临沂市Linyi40.00color3日照市Rizhao40.00color3德州市Dezhou0.00color1聊城市Liaocheng0.00color1滨州市Binzhou0.00color1菏泽市Heze0.00color1山西临汾市Linfen0.00color1晋中市Jinzhong0.00color1阳泉市Yangquan0.00color1大同市Datong0.00color1运城市Yuncheng0.00color1晋城市Jincheng0.00color1朔州市Shuozhou0.00color1吕梁市Lvliang0.00color1长治市Changzhi0.00color1忻州市Xinzhou0.00color1太原市Taiyuan40.00color3甘肃兰州市 lanzhou40.00color3嘉峪关市Jiayuguan0.00color1金昌市 Jinchang0.00color1白银市 Baiyin0.00color1天水市 Tianshui0.00color1武威市 Wuwei0.00color1张掖市 Zhangye0.00color1平凉市 Pingliang0.00color1酒泉市 Jiuquan0.00color1庆阳市 Qingyang0.00color1定西市 Dingxi0.00color1陇南市 longnan0.00color1临夏州 Linxia0.00color1甘南州 Gannan0.00color1仔细核对无误。