气泡+热力型中国数据地图ExcelPro的图表博客xy人口数GDP%标签颜色2、图例1北京24.8921.4620693%color42安徽25.7413.7459883%color413重庆19.8011.5129452%color324福建26.418.4137483%color435甘肃18.0016.5225541%color146广东23.696.131059410%广东,10594color757广西20.516.1446822%color368贵州19.448.7534841%color279海南21.001.718870%color1810河北24.3419.5172884%color5911黑龙江30.3928.3138342%color31012河南23.1215.1194065%color613湖北22.8412.9157794%color414湖南22.279.9466394%color415江苏26.9214.9879209%江苏,7919.98color716江西24.829.8545042%color317吉林29.9025.0727612%color318辽宁28.4922.8443894%color519内蒙古23.5323.9324903%color320宁夏19.0018.186470%color121青海12.7617.595730%color122山东25.7417.6796859%山东,9684.87color723上海28.2813.3223803%color424陕西20.7215.3637533%color325山西22.4118.1336112%color226四川16.7612.6780764%四川,8076.2color527台湾28.536.5100%color128天津25.6220.2614132%color329新疆7.3723.6322331%color230西藏8.0014.003080%color131云南15.487.0446592%color232浙江27.5011.2154776%浙江,5477color633香港23.874.5700%color134澳门23.014.0000%color1图例3.002.0010001000color43.003.0030003000color43.004.5080008000color43.007.002000020000color42013年人口2014年GDP占比%广东29863山东25326江苏24738浙江17633河南14234河北13387上海11658辽宁10418四川9657北京8879湖北8451福建8440湖南8366黑龙江7081安徽6906内蒙古6140山西5465广西5386江西5323天津5014陕西4806吉林4693云南4260重庆3938新疆3305贵州2543甘肃2494海南1121宁夏769青海706西藏326香港1000澳门1000台湾100002、图例3、阀值5、填色0%~1%0%color11%~2%1%color22%~3%2%color33%~4%3%color44%~5%4%color55%~6%5%color66%~6%color7刘万祥搜狐博客:新浪微博:豆瓣读书:图表之道:图表书架:填充气泡颜色ExcelPro的图表博客广东,10594江苏,7919.98山东,9684.87四川,8076.2浙江,547710003000800020000气泡+热力型中国数据地图ExcelPro的图表博客0%~1%1%~2%2%~3%3%~4%4%~5%5%~6%6%~ExcelPro的图表博客广东,10594江苏,7919.98山东,9684.87四川,8076.2浙江,547710003000800020000气泡+热力型中国数据地图ExcelPro的图表博客0%~1%1%~2%2%~3%3%~4%4%~5%5%~6%6%~6、OK,将拍照图片copy走吧!ExcelPro的图表博客广东,10594江苏,7919.98山东,9684.87四川,8076.2浙江,547710003000800020000气泡+热力型中国数据地图ExcelPro的图表博客0%~1%1%~2%2%~3%3%~4%4%~5%5%~6%6%~ExcelPro的图表博客广东,10594江苏,7919.98山东,9684.87四川,8076.2浙江,547710003000800020000气泡+热力型中国数据地图ExcelPro的图表博客0%~1%1%~2%2%~3%3%~4%4%~5%5%~6%6%~使用条款Copyright(c)2012byExcelPro的图表博客本使用条款不得被修改、删除。Allrightsarereserved.Thisworkbookmaynotbereprintedordistributedinelectronic,print,web,orotherformatwithoutexpresswrittenpermissionfromtheauthor.ThisworkbookisdesignedtoprovideinformationaboutMicrosoftExcel.Everyefforthasbeenmadetomakethemascompleteandaccurateaspossible.Theinformationisprovidedonan“asis”basis.TheauthorandExcelPro.blog.sohu.comshallhaveneitherliabilitynorresponsibilitytoanypersonorentitywithrespecttoanylossordamagesarisingfromthecontentsoruseoftheseworkbooks.Youmaymakearchivalcopiesandcustomizethistemplate(theSoftware)forpersonaluseorforyourcompanyuse.Thecustomizedtemplate(withyourspecificpersonalorcompanyinformation)maybeusedandsharedwithinyourcompany,butthistemplateoranydocumentincludingorderivedfromthistemplatemayNOTbesold,distributed,orplacedonapublicserversuchastheinternet.Caution:Thisspreadsheetisforeducationalandillustrativepurposesonlyandshouldnotbeconstruedasfinancialadvice.Theresultsmaynotreflectrealityandmaynotapplytoyourspecificsituation.本文档作为《用地图说话》一书的配套范例文件而建立,仅作为该书读者个人对照书本阅读、理解、学习之用途,售、商业培训等任何营利性质的用途,也不得发布到互联网上任何网站、论坛、社区、博客等途径提供免费或收费下载本文档仅作为该书案例讲解和读者学习理解之用途,已尽量设计得正确。但若读者将其用于公司内部实际工作使用,本文档并不保证适合所有的应用场景,无论读者是否进行定制化修改,本作者对由此所可能引起的任何错误、损失等不承担任何责任。Allrightsarereserved.Thisworkbookmaynotbereprintedordistributedinelectronic,print,web,orotherformatwithoutexpresswrittenpermissionfromtheauthor.ThisworkbookisdesignedtoprovideinformationaboutMicrosoftExcel.Everyefforthasbeenmadetomakethemascompleteandaccurateaspossible.Theinformationisprovidedonan“asis”basis.TheauthorandExcelPro.blog.sohu.comshallhaveneitherliabilitynorresponsibilitytoanypersonorentitywithrespecttoanylossordamagesarisingfromthecontentsoruseoftheseworkbooks.Youmaymakearchivalcopiesandcustomizethistemplate(theSoftware)forpersonaluseorforyourCaution:Thisspreadsheetisforeducationalandillustrativepurposesonlyandshouldnotbeconstruedas一书的配套范例文件而建立,仅作为该书读者个人对照书本阅读、理解、学习之用途,不得用于转让、出售、商业培训等任何营利性质的用途,也不得发布到互联网上任何网站、论坛、社区、博客等途径提供免费或收费下载。本文档仅作为该书案例讲解和读者学习理解之用途,已尽量设计得正确。但若读者将其用于公司内部实际工作使用,本文档并不保证适合所有的应用场景,无论读者是否进行定制化修改,本作者对由此所可能引起的任何错误、损失等不承担任何责任。Theinformationisprovidedonan“asis”basis.TheauthorandExcelPro.blog.sohu.comshallhaveneitherliabilitynorresponsibilitytoanypersonorentitywithrespecttoanylossordamagesarisingfromthecontentsoruseoftheseworkbooks.商务人士最值得阅读的职场充电图书!书名:作者:出版:定价:豆瓣:京东:当当:卓越:搜狐博客:新浪微博:图表之道:图表书架:当当卓越畅销图书商务人士最值得阅读的职场充电图书!《Excel图表之道--如何制作专业有效的商务图表》(全彩)刘万祥电子工业出版社*博文视点59元://t.cn/hejun9://sinaurl.cn/7Pd3O://excelpro.blog.sohu.com/#tp_861253cce8a@刘万祥ExcelPro简称省区市GDP/亿元常住人口/万GDP占比%人口占比%人均GDP/元人均GDP/美元津天津1437014132.3%1.0%1016891