《編號 (278)》由會員分享,可在線閱讀,更多相關(guān)《編號 (278)(22頁珍藏版)》請?jiān)谘b配圖網(wǎng)上搜索。
1、中中國國數(shù)數(shù)據(jù)據(jù)地地圖工工具具只要您輸入各省數(shù)據(jù),設(shè)置分檔數(shù)值和填充底色,即可快速生成專業(yè)的中國數(shù)據(jù)地圖!原創(chuàng) ExcelPro的圖表博客 ExcelP紅色標(biāo)注標(biāo)識下的填色區(qū)域?yàn)槟枰畹牡胤?。不要修改其他地方,以免出現(xiàn)錯誤。1、在D列輸入你的數(shù)據(jù),沒有的可填0。-2、設(shè)置數(shù)據(jù)分檔及圖例。-數(shù)值:安徽anhui6906分檔參考:0-5K0北京beijing88795-10K5000重慶chongqing3938最大值:2986310-15K10000福建fujian8440最小值:32615-20K15000甘肅gansu249420K+20000廣東guangdong29863廣西guang
2、xi5386貴州guizhou2543海南hainan1121河北hebei13387active regzhejiang黑龍江h(huán)eilongjiang7081value#河南henan14234codecolor4湖北hubei8451湖南hunan8366江蘇jiangsu24738江西jiangxi5323吉林jilin4693遼寧liaoning10418內(nèi)蒙古neimenggu6140寧夏ninxia769青海qinghai706山東shandong25326上海shanghai11658陜西shanxi34806山西shanxi15465四川sichuan9657天津tianjin
3、5014新疆xinjiang3305西藏xizang326云南yunnan4260浙江zhejiang176332008的GDP廣東29863山東25326江蘇24738浙江17633河南14234河北13387上海11658遼寧10418四川9657北京8879湖北8451福建8440湖南8366黑龍江7081安徽6906內(nèi)蒙古6140山西5465廣西5386江西5323天津5014陜西4806吉林4693云南4260重慶3938新疆3305貴州2543甘肅2494海南1121寧夏769青海706西藏3263、點(diǎn)擊按鈕開始填色。-4、OK!可以復(fù)制下面的數(shù)據(jù)地圖了。color1color2c
4、olor3color4color5您可根據(jù)此文件改造出成省、市的分區(qū)數(shù)據(jù)地圖!0-5K5-10K10-15K15-20K20K+ExcelPro的圖表博客只要您輸入各省數(shù)據(jù),設(shè)置分檔數(shù)值和填充底色,即可快速生成專業(yè)的中國數(shù)據(jù)地圖!紅色標(biāo)注標(biāo)識下的填色區(qū)域?yàn)槟枰畹牡胤?。不要修改其他地方,以免出現(xiàn)錯誤。2、設(shè)置數(shù)據(jù)分檔及圖例。-0-5K5-10K10-15K15-20K20K+ExcelPro的圖表博客使用條款Copyright(c)2010 by ExcelPro的圖表博客ExcelP本使用條款不得被修改、刪除。All rights are reserved.This workbook ma
5、y not be reprinted or distributed in electronic,print,web,or other format without express written permission from the author.This workbook is designed to provide information about Microsoft Excel.Every effort has been made to make them as complete and accurate as possible.The information is provided
6、 on an“as is”basis.The author and ExcelP shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the contents or use of these workbooks.You may make archival copies and customize this template(the Software)for personal use or for yourc
7、ompany use.The customized template(with your specific personal or company information)may be used and shared within your company,but this template or any document including or derived fromthis template may NOT be sold,distributed,or placed on a public server such as the internet.Caution:This spreads
8、heet is for educational and illustrative purposes only and should not be construed asfinancial advice.The results may not reflect reality and may not apply to your specific situation.本文檔作為Excel圖表之道一書的配套范例文件而建立,僅作為該書讀者個人對照書本閱讀、理解、學(xué)習(xí)之用途,不得用于轉(zhuǎn)讓、出售、商業(yè)培訓(xùn)等任何營利性質(zhì)的用途,也不得發(fā)布到互聯(lián)網(wǎng)上任何網(wǎng)站、論壇、社區(qū)、博客等途徑提供免費(fèi)或收費(fèi)下載。All
9、rights are reserved.This workbook may not be reprinted or distributed in electronic,print,web,or other format without express written permission from the author.This workbook is designed to provide information about Microsoft Excel.Every effort has been made to make them as complete and accurate as
10、possible.The information is provided on an“as is”basis.The author and ExcelP shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the contents or use of these workbooks.You may make archival copies and customize this template(the So
11、ftware)for personal use or for yourCaution:This spreadsheet is for educational and illustrative purposes only and should not be construed as本文檔作為Excel圖表之道一書的配套范例文件而建立,僅作為該書讀者個人對照書本閱讀、理解、學(xué)習(xí)之用途,不得用于轉(zhuǎn)讓、出售、商業(yè)培訓(xùn)等任何營利性質(zhì)的用途,也不得發(fā)布到互聯(lián)網(wǎng)上任何網(wǎng)站、論壇、社區(qū)、博客等途徑提供免費(fèi)或收費(fèi)下載。The information is provided on an“as is”basis.The author and ExcelP shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the contents or use of these workbooks.