市级-中国数据地图--分档填色表格文件下载.xls
- 文档编号:827669
- 上传时间:2023-04-29
- 格式:XLS
- 页数:30
- 大小:3.01MB
市级-中国数据地图--分档填色表格文件下载.xls
《市级-中国数据地图--分档填色表格文件下载.xls》由会员分享,可在线阅读,更多相关《市级-中国数据地图--分档填色表格文件下载.xls(30页珍藏版)》请在冰点文库上搜索。
免责声明:
并不保证地市图形完全对应准确,商用请自行仔细核对无误。
模型建立:
ExcelPro的图表博客http:
/ExcelP2010.11.61、填入数据:
2、设置图例:
3、设置阀值:
在D列填入/粘贴数值G11:
H15将被作为图例输入分档的下限值数值:
填色:
云南德宏州Dehong40.45color310200红河州Honghe43.24color32204020临沧市Lincang49.83color33406040文山州Wenshan94.83color54608060昆明市Kunming73.87color4580+80曲靖市Qujing25.73color26+玉溪市Yuxi64.03color47昭通市Shaotong69.05color48大理州Dali51.26color39楚雄州Chuxiong35.50color210普洱市Puer22.92color2保山市Baoshan17.77color1以上预留了5个分档的位置,若需要可往下添加版纳州Xishuangbanna89.92color5迪庆州DiqingYN29.58color2怒江州Nujiang47.49color3丽江市Lijiang28.52color2广西南宁Nanning0.68color1柳州Liuzhou97.05color5以下仅为备用百色Baise95.46color5梧州Wuzhou55.39color3钦州Qinzhou0.23color1最小值:
0.21来宾Laibin68.59color4最大值:
99.98崇左Chongzuo35.81color2所分档数:
5桂林Guilin55.52color3间隔参考:
19.95557贺州Hezhou91.06color5河池Hechi68.05color4北海Beihai80.57color5防城港Fangchenggang41.74color3贵港Guigang74.48color4玉林Yulin34.90color2黑龙江哈尔滨市Haerbin86.61color5齐齐哈尔市Qiqihaer68.29color4牡丹江市Mudanjiang50.13color3佳木斯市Jiamusi86.05color5ExcelPro的的图图表表博博客客大庆市Daqing52.70color3七台河市Qitaihe44.83color3搜狐博客:
绥化市Suihua62.59color4新浪微博:
伊春市YichunHLJ13.60color1豆瓣读书:
鸡西市Jixi46.15color3图表之道:
黑河市Heihe77.36color4图表书架:
鹤岗Hegang76.67color4双鸭山Shuangyashan35.33color2大兴安岭地区Daxinganling26.23color2陕西西安市Xian19.09color1铜川市Tongchuan30.11color2宝鸡市Baoji72.86color4咸阳+杨凌市Xianyang39.83color2渭南市Weinan81.08color5延安市Yanan60.32color4汉中市Hanzhong60.30color4榆林市YulinSX10.84color1安康市Ankang45.83color3商洛市Shangluo20.69color2辽宁沈阳Shenyang18.49color1大连Dalian94.25color5鞍山Anshan51.18color3抚顺Fushun29.03color2本溪Benxi16.36color1丹东Dandong62.17color4锦州Jinzhou72.41color4营口Yingkou10.90color1阜新Fuxin4.51color1辽阳Liaoyang69.87color4铁岭Tieling29.32color2朝阳Chaoyang46.10color3盘锦Panjin66.34color4葫芦岛Huludao20.13color2贵阳市Guiyang75.30color4遵义市Zunyi53.24color3安顺市Anshun20.64color2黔南州Qiannan20.82color2黔东南州Qiandongnan1.58color1铜仁地区Tongren93.02color5毕节地区Bijie7.27color1六盘水市Liupanshui30.27color2黔西南州Qianxinan9.06color1西藏拉萨市Lasa84.43color5日喀则Rikeze90.87color5昌都Changdu59.88color3林芝Linzhi17.59color1山南Shannan1.84color1阿里Ali5.11color1那曲Naqu55.70color3福建福州Fuzhou13.78color1厦门Xiamen49.05color3泉州Quanzhou40.86color3漳州Zhangzhou57.69color3莆田Putian79.73color4三明Sanming83.91color5宁德Ningde74.11color4龙岩Longyan17.78color1南平Nanping71.93color4湖北武汉市Wuhan65.51color4黄石市Huangshi99.56color5十堰市Shiyan35.13color2宜昌Yichang16.89color1襄樊市Xiangfan10.83color1鄂州Ezhou80.54color5荆门市Jingmen17.99color1孝感市Xiaogan14.96color1荆州市Jingzhou41.93color3黄冈市Huanggang97.82color5咸宁市Xianning84.27color5随州Suizhou56.86color3恩施州Enshi96.41color5神农架林区Shennongjia2.18color1天门市Tianmen32.23color2潜江Qianjiang81.07color5仙桃市Xiantao72.76color4海南海口市Haikou50.27color3三亚市Sanya95.71color5海南其它HainanQT60.69color4浙江杭州市Hangzhou80.77color5宁波市Ningbo61.08color4温州市Wenzhou52.11color3嘉兴市Jiaxing45.21color3湖州市Huzhou23.63color2绍兴市Shaoxing2.46color1金华市Jinhua77.85color4衢州市Quzhou48.13color3舟山市Zhoushan35.71color2台州市Taizhou85.66color5丽水市Lishui32.94color2江西南昌市Nanchang12.65color1萍乡市Pingxiang52.51color3新余市Xinyu43.75color3九江市Jiujiang0.21color1抚州市FuzhouJX20.58color2赣州市Ganzhou90.48color5景德镇市Jingdezhen92.04color5吉安市Jian41.98color3上饶市Shangrao58.82color3宜春市Yichun64.49color4鹰潭市Yingtan11.07color1新疆乌鲁木齐市Urumqi71.42color4克拉玛依市Karamay55.28color3哈密地区Hami25.40color2吐鲁番地区Turpan33.09color2博州Boertala9.02color1阿勒泰地区Aletai61.14color4塔城地区Tacheng71.48color4昌吉州Changji57.73color3伊犁州直Yili41.81color3巴州Bayinguole76.65color4阿克苏地区Akesu57.17color3克州Kezilesu90.30color5喀什地区Kashgar69.72color4和田地区Hotan28.40color2吉林长春Changchun51.24color3吉林Jilin75.15color4通化Tonghua38.69color2四平Siping20.11color2白城Baicheng84.37color5白山Baishan49.02color3松源Songyuan34.11color2辽源Liaoyuan60.31color4延边Yanbian52.00color3安徽合肥市Hefei39.72color2芜湖市Wuhu98.06color5蚌埠市Bengbu24.82color2淮南市Huainan22.47color2马鞍山市Maanshan96.03color5淮北市Huaibei29.16color2铜陵市Tongling85.47color5安庆市Anqing1.00color1黄山市Huangshan38.68color2滁州市Chuzhou11.79color1阜阳市Fuyang76.40color4亳州市bozhou75.32color4宿州市SuzhouAH2.59color1六安市Liuan90.20color5宣城市Xuancheng66.41color4巢湖市Chaohu28.25color2池州市Chizhou7.26color1银川市Yinchuan13.57color1石嘴山市Shizuishan7.29color1吴忠市Wuzhong49.16color3固原市Guyuan28.79color2中卫市Zhongwei0.74color1凉山Liangshan99.98color5四川成都Chengdu87.19color5自贡Zigong29.58color2攀枝花Panzhihua8.48color1泸州Luzhou5.20color1德阳Deyang64.56color4绵阳Mianyang67.88color4广元Guangyuan29.87color2遂宁Suining27.90color2内江Neijiang38.28color2乐山Leshan88.05color5南充Nanchong0.87color1宜宾Yibin3.79color1广安Guangan21.40color2雅安Yaan27.90color2阿坝州Aba72.77color4甘孜州Ganzi96.46color5巴中Bazhong22.45color2眉山Meishan20.31color2资阳Ziyang75.66color4达州Dazhou71.50color4北京Beijing46.74color3内蒙古呼和浩特市huhehaote21.14color2包头市Baotou2.83color1乌海市Wuhai64.47color4赤峰市Chifeng13.57color1通辽市Tongliao54.15color3鄂尔多斯市Eerduosi57.60color3呼伦贝尔市Hulunbier66.87color4乌兰察布市Wulanchabu14.60color1巴彦淖尔市Bayanzhuoer35.24color2兴安盟Xingan79.09color4锡林郭勒盟Xilinguole21.30color2阿拉善盟Alashan13.66color1河北廊坊Langfang30.66color2邢台市Xingtai51.23color3石家庄Shijiazhuang62.99color4保定市Baoding58.36color3邯郸市Handan60.49color4唐山市Tangshan86.69color5承德市Chengde45.22color3沧州市Cangzhou42.84color3张家口市Zhangjiakou76.00color4秦皇岛市Qinhuangdao32.42color2衡水市Hengshui8.37color1重庆Chongqing18.59color1上海Shanghai71.14color4宁夏西宁市Xining60.22color4海东地区Haidong18.44color1海北州Haibei30.81color2黄南州Huangnan89.12color5海南州Hainan4.71color1果洛州Guoluo17.90color1玉树州Yushu29.85color2海西州Haixi55.00color3湖南长沙市Changsha89.88color5株洲市Zhuzhou85.86color5湘潭市Xiangtan8.87color1衡阳市Hengyang63.40color4邵阳市Shaoyang21.83color2岳阳市Yueyang98.42color5常德市Changde23.31color2张家界市Zhangjiajie65.19color4益阳市Yiyang88.85color5郴州市Chenzhou4.29color1永州市Yongzhou44.40color3怀化市Huaihua21.28color2娄底市Loudi88.94color5湘西自治州xiangxi43.25color3河南郑州市Zhengzhou78.95color4开封市Kaifeng24.94color2洛阳市Luoyang5.96color1平顶山市Pingdingshan67.87color4安阳市Anyang76.61color4鹤壁市Hebi35.35color2新乡市Xinxiang68.53color4焦作市Jiaozuo92.03color5濮阳市Puyang87.34color5许昌市Xuchang43.78color3漯河市Luohe28.20color2三门峡Sanmenxia74.57color4南阳市Nanyang49.02color3商丘市Shangqiu69.87color4信阳市Xinyang22.88color2周口市Zhoukou66.76color4驻马店市Zhumadian40.64color3济源市Jiyuan91.61color5讲师南京Nanjing73.65color4无锡Wuxi70.38color4徐州Xuzhou28.32color2常州Changzhou72.47color4苏州Suzhou65.94color4南通Nantong30.33color2连云港Lianyungang15.61color1淮安Huaian25.82color2盐城Yancheng45.30color3扬州Yangzhou27.28color2镇江Zhenjiang83.65color5泰州TaizhouJS4.73color1宿迁Suqian57.52color3天津Tianjin26.57color2广东广州Guangzhou56.13color3深圳Shenzhen94.65color5韶关Shaoguan81.42color5珠海Zhuhai7.41color1汕头Shantou92.10color5佛山Fuoshan71.06color4江门Jiangmen12.74color1湛江Zhanjiang37.30color2茂名Maoming3.45color1肇庆Zhaoqing81.92color5惠州Huizhou97.39color5梅州Meizhou68.92color4汕尾Shanwei81.43color5河源Heyuan57.33color3阳江Yangjiang70.46color4清远Qingyuan64.36color4东莞Dongwan79.29color4中山Zhongshan56.29color3潮州Chaozhou78.64color4揭阳Jieyang92.53color5云浮Yunfu51.51color3山东济南市Jinan86.98color5青岛市Qingdao91.95color5淄博市Zibo56.24color3枣庄市Zaozhuang94.03color5东营市Dongying8.83color1烟台市Yantai84.40color5潍坊市Weifang56.20color3威海市Weihai0.90color1泰安市Taian92.75color5莱芜市Laiwu29.85color2济宁市Jining39.28color2临沂市Linyi36.35color2日照市Rizhao87.20color5德州市Dezhou5.36color1聊城市Liaocheng72.82color4滨州市Binzhou64.88color4菏泽市Heze10.66color1山西临汾市Linfen90.85color5晋中市Jinzhong83.43color5阳泉市Yangquan70.97color4大同市Datong4.56color1运城市Yuncheng19.95color1晋城市Jincheng64.45color4朔州市Shuozhou50.92color3吕梁市Lvliang62.04color4长治市Changzhi66.00color4忻州市Xinzhou46.64color3太原市Taiyuan97.36color5甘肃兰州市lanzhou82.93color5嘉峪关市Jiayuguan47.73color3金昌市Jinchang64.35color4白银市Baiyin77.11color4天水市Tianshui42.45color3武威市Wuwei72.44color4张掖市Zhangye28.31color2平凉市Pingliang69.92color4酒泉市Jiuquan46.98color3庆阳市Qingyang76.38color4定西市Dingxi73.08color4陇南市longnan6.03color1临夏州Linxia11.61color1甘南州Gannan51.30color34、生成地图5、OK,复制走吧!
color1color2color3color4color5http:
/ExcelPhttp:
/byExcelPro的图表博客3、设置阀值:
输入分档的下限值以上预留了5个分档的位置,若需要可往下添加ExcelPro的的图图表表博博客客BengbuPuerHongheWenshanXishangbannaYuxiLincangShaotongDaliChuxiongDehongBaoshanDiqingNujiangLijiangKunmingQujingBaiseLiuzhouNanningGuigangWuzhouQinzhouLaibinChongzuoGuilinHezhouHechiBeihaiFangchenggangYulinHaerbinQiqihaerMudanjiangJiamusiDaqingQitaiheSuihuaYichunJixiHeiheFuyangHuainanliuanHefeiyangzhouHegangShuangyashanDaxinganlingXianTongchuanBaojiWeinanYananHanzhongYulinAnkangShangluoXianyangShenyangDalianAnshanFushunBenxiDandongJinzhouYingkouFuxinLiaoyangTielingChaoyangPanjinHuludaoGuiyangZunyiAnshunQiannanQiandongnanTongrenBijieLiupanshuiQianxinanLasaRikezeChangduLinzhiShannanNaquAliFuzhouXiamenQuanzhouZhangzhouPutianSanmingNingdeLongyanNanpingWuhanHuangshiShiyanYichangXiangfanezhouJingmenXiaoganJingzhouHuanggangXianningSuizhouEnshiShennongjiaTianmenQianjiangXiantaoHaikouSanyaHainanHangzhouNingboWenzhouJiaxingHuzhouShaoxingJinhuaQuzhouZhoushanTaizhouLishuiNanchangPingxiangJianXinyuJiujiangGanzhouJingdezhenShangraoYingtanYichunFuzhouUrumqiKaramayHamiTurpanBoertalaAletaiTachengChangjiYiliBayinguoleAkesuKezilesuKashgarHotanChangchunJilinTonghuaSipingBaichengBaishanSongyuanLiaoyuanYanbianWuhuMaanshanHuaibeiTonglingAnqingHuangshanChuzhouBozhouSuzhouXuanchengChaohuChizhouYinchuanShizuishanWuzhongGuyuanZhongweiWuduZigongPanzhihuaLuzhouDeyangMianyangGuangyuanSuiningNeijiangLeshanYibinNanchongGuanganYaanAbaGanziBazhongMeishanZiyangDazhouChengduLiangshanHuhehaoteBaotouWuhaiChifengTongliaoEerduosiHulunbierWulanchabuBayanzhuoerXinganXilinguoleAlashanLangfangBeijingTianjinXingtaiShijiazhuangBaodingHandanTangshanChengdeCangzhouZhangjiakouQinhuangdaoHengshuiShanghaiChongqingXiningHaidongHaibeiHuangnanHainanGuoluoHaixiYushuChangshaZhuzhouXiangtanHengyangShaoyangYueyangChangdeZhangjiajieYiyangChenzhouYongzhouHuaihuaXiangsiLoudiZhengzhouKaifengLuoyangPingdingshanAnyangHebiXinxiangJiaozuoPuyangXuchangLuoheSanmenxiaNanyangShangqiuXinyangZhoukouZhumadianJiyuanNanjingWuxiXuzhouChangzhouSuzhouNantongLianyungangHuaianSuqianYanchengZhenjiangTaizhouGuangzhouShenzhenShaoguanZhuhaiAomenXianggangShantouFuoshanJiangmenZhanj
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 市级 中国 数据 地图 分档