中国数据地图-到市级-分档填色.xls
- 文档编号:700701
- 上传时间:2023-04-29
- 格式:XLS
- 页数:32
- 大小:4.19MB
中国数据地图-到市级-分档填色.xls
《中国数据地图-到市级-分档填色.xls》由会员分享,可在线阅读,更多相关《中国数据地图-到市级-分档填色.xls(32页珍藏版)》请在冰点文库上搜索。
中国数据地图(到市级)生成模板地图绘制:
郑薇Vivi。
免责声明:
并不保证地市图形完全对应准确,商用请自行仔细核对无误。
模型建立:
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.42color2石家庄Shijiazhuang18.24color1保定市Baoding5.86color1邯郸市Handan49.02color3唐山市Tangshan56.02color3承德市Chengde56.41color3沧州市Cangzhou46.97color3张家口市Zhangjiakou28.26color2秦皇岛市Qinhuangdao25.16color2衡水市Hengshui12.59color1重庆Chongqing4.84color1上海Shanghai91.16color5宁夏西宁市Xining43.07color3海东地区Haidong22.83color2海北州Haibei45.99color3黄南州Huangnan5.94color1海南州Hainan27.93color2果洛州Guoluo22.02color2玉树州Yushu21.54color2海西州Haixi5.56color1湖南长沙市Changsha90.45color5株洲市Zhuzhou11.48color1湘潭市Xiangtan10.87color1衡阳市Hengyang19.40color1邵阳市Shaoyang67.72color4岳阳市Yueyang24.40color2常德市Changde24.61color2张家界市Zhangjiajie57.02color3益阳市Yiyang67.42color4郴州市Chenzhou32.99color2永州市Yongzhou59.06color3怀化市Huaihua2.87color1娄底市Loudi77.04color4湘西自治州xiangxi60.33color4河南郑州市Zhengzhou80.46color5开封市Kaifeng27.93color2洛阳市Luoyang22.02color2平顶山市Pingdingshan71.71color4安阳市Anyang33.27color2鹤壁市Hebi26.15color2新乡市Xinxiang87.86color5焦作市Jiaozuo69.40color4濮阳市Puyang54.15color3许昌市Xuchang35.91color2漯河市Luohe45.38color3三门峡Sanmenxia53.62color3南阳市Nanyang11.47color1商丘市Shangqiu13.19color1信阳市Xinyang7.13color1周口市Zhoukou33.82color2驻马店市Zhumadian65.80color4济源市Jiyuan61.96color4讲师南京Nanjing30.94color2无锡Wuxi84.25color5徐州Xuzhou12.23color1常州Changzhou89.12color5苏州Suzhou70.34color4南通Nantong56.11color3连云港Lianyungang38.85color2淮安Huaian6.04color1盐城Yancheng63.67color4扬州Yangzhou87.70color5镇江Zhenjiang82.70color5泰州TaizhouJS2.79color1宿迁Suqian28.51color2天津Tianjin74.75color4广东广州Guangzhou97.78color5深圳Shenzhen1.59color1韶关Shaoguan81.77color5珠海Zhuhai55.28color3汕头Shantou26.81color2佛山Fuoshan75.08color4江门Jiangmen98.31color5湛江Zhanjiang54.19color3茂名Maoming6.97color1肇庆Zhaoqing60.43color4惠州Huizhou77.20color4梅州Meizhou63.37color4汕尾Shanwei58.13color3河源Heyuan33.87color2阳江Yangjiang12.78color1清远Qingyuan23.14color2东莞Dongwan79.92color4中山Zhongshan71.13color4潮州Chaozhou41.26color3揭阳Jieyang83.58color5云浮Yunfu76.61color4山东济南市Jinan62.01color4青岛市Qingdao84.99color5淄博市Zibo62.07color4枣庄市Zaozhuang61.91color4东营市Dongying69.72color4烟台市Yantai39.28color2潍坊市Weifang51.75color3威海市Weihai27.24color2泰安市Taian73.86color4莱芜市Laiwu23.91color2济宁市Jining77.41color4临沂市Linyi81.75color5日照市Rizhao84.60color5德州市Dezhou64.29color4聊城市Liaocheng30.18color2滨州市Binzhou7.54color1菏泽市Heze89.84color5山西临汾市Linfen62.76color4晋中市Jinzhong94.58color5阳泉市Yangquan84.42color5大同市Datong63.42color4运城市Yuncheng74.81color4晋城市Jincheng46.13color3朔州市Shuozhou5.46color1吕梁市Lvliang64.16color4长治市Changzhi91.31color5忻州市Xinzhou85.09color5太原市Taiyuan83.39color5甘肃兰州市lanzhou83.71color5嘉峪关市Jiayuguan93.26color5金昌市Jinchang53.61color3白银市Baiyin72.02color4天水市Tianshui21.52color2武威市Wuwei87.90color5张掖市Zhangye36.50color2平凉市Pingliang60.10color4酒泉市Jiuquan50.18color3庆阳市Qingyang27.93color2定西市Dingxi45.80color3陇南市longnan63.41color4临夏州Linxia48.26color3甘南州Gannan83.24color54、生成地图5、OK,复制走吧!
color1color2color3color4color5http:
/ExcelPhttp:
/byExcelPro的图表博客3、设置阀值:
输入分档的下限值以上预留了5个分档的位置,若需要可往下添加ExcelPro的的图图表表博博客客BengbuPuerHongheWenshanXishangbannaYuxiLincangShaotongDaliChuxiongDehongBaoshanDiqingNujiangLijiangKunmingQujingBaiseLiuzhouNanningGuigangWuzhouQinzhouLaibinChongzuoGuilinHezhouHechiBeihaiFangchenggangYulinHaerbinQiqihaerMudanjiangJiamusiDaqingQitaiheSuihuaYichunJixiHeiheFuyangHuainanliuanHefeiyangzhouHegangShuangyashanDaxinganlingXianTongchuanBaojiWeinanYananHanzhongYulinAnkangShangluoXianyangShenyangDalianAnshanFushunBenxiDandongJinzhouYingkouFuxinLiaoyangTielingChaoyangPanjinHuludaoGuiyangZunyiAnshunQiannanQiandongnanTongrenBijieLiupanshuiQianxinanLasaRikezeChangduLinzhiShannanNaquAliFuzhouXiamenQuanzhouZhangzhouPutianSanmingNingdeLongyanNanpingWuhanHuangshiShiyanYichangXiangfanezhouJingmenXiaoganJingzhouHuanggangXianningSuizhouEnshiShennongjiaTianmenQianjiangXiantaoHaikouSanyaHainanHangzhouNingboWenzhouJiaxingHuzhouShaoxingJinhuaQuzhouZhoushanTaizhouLishuiNanchangPingxiangJianXinyuJiujiangGanzhouJingdezhenShangraoYingtanYichunFuzhouUrumqiKaramayHamiTurpanBoertalaAletaiTachengChangjiYiliBayinguoleAkesuKezilesuKashgarHotanChangchunJilinTonghuaSipingBaichengBaishanSongyuanLiaoyuanYanbianWuhuMaanshanHuaibeiTonglingAnqingHuangshanChuzhouBozhouSuzhouXuanchengChaohuChizhouYinchuanShizuishanWuzhongGuyuanZhongweiWuduZigongPanzhihuaLuzhouDeyangMianyangGuangyuanSuiningNeijiangLeshanYibinNanchongGuanganYaanAbaGanziBazhongMeishanZiyangDazhouChengduLiangshanHuhehaoteBaotouWuhaiChifengTongliaoEerduosiHulunbierWulanchabuBayanzhuoerXinganXilinguoleAlashanLangfangBeijingTianjinXingtaiShijiazhuangBaodingHandanTangshanChengdeCangzhouZhangjiakouQinhuangdaoHengshuiShanghaiChongqingXiningHaidongHaibeiHuangnanHainanGuoluoHaixiYushuChangshaZhuzhouXiangtanHengyangShaoyangYueyangChangdeZhangjiajieYiyangChenzhouYongzhouHuaihuaXiangsiLoudiZhengzhouKaifengLuoyangPingdingshanAnyangHebiXinxiangJiaozuoPuyangXuchangLuoheSanmenxiaNanyangShangqiuXinyangZhoukouZhumadianJiyuanNanjingWuxiXuzhouChangzhouSuzhouNantongLianyungangHuaianSuqianYanchengZhenjiangTaizhouGuangzhouShenzhenShaoguanZhuhaiAomenXianggangShantouFuoshanJiangmenZhanjian
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 中国 数据 地图 到市级 分档
![提示](https://static.bingdoc.com/images/bang_tan.gif)