Discover everything Scribd has to offer, including books and audiobooks from major publishers.
Office 365 Excel Powermap Free Trial CancelStart Free Trial Cancel anytime.Office 365 Excel Powermap Download Now SaveOffice 365.pptx Uploaded by juan santamaria 0 0 upvotes 0 0 downvotes 19 views 27 pages Document Information click to expand document information Date uploaded Apr 23, 2019 Copyright All Rights Reserved Available Formats PPTX, PDF, TXT or read online from Scribd Share this document Share or Embed Document Sharing Options Share on Facebook, opens a new window Facebook Share on Twitter, opens a new window Twitter Share on LinkedIn, opens a new window LinkedIn Share with Email, opens mail client Email Copy Text Copy Link Did you find this document useful 0 0 upvotes, Mark this document as useful 0 0 downvotes, Mark this document as not useful Is this content inappropriate Report this Document Download Now save Save Office 365.pptx For Later 19 views 0 0 upvotes 0 0 downvotes Office 365.pptx Uploaded by juan santamaria Description: Full description save Save Office 365.pptx For Later 0 0 upvotes, Mark this document as useful 0 0 downvotes, Mark this document as not useful Embed Share Print Download Now Jump to Page You are on page 1 of 27 Search inside document.
Browse Books Site Directory Site Language: English Change Language English Change Language. Office 365 Excel Powermap Free Plugin CalledIn this tutorial Ill show you how make an awesome looking map in Excel in under 5 minutes with a free plugin called PowerMap (formerly GeoFlow). Initially the plugin was restricted only for MS Office 365 subscribers and owners of an expensive MS Office Professional Plus suite but recently it has been released for all MS Excel 2013 users. Both 32bit and 64bit Windows version are supported but it will work only with Excel 2013 (no previous Excel version is supported). If you successfully install the plugin, you should be able to see it in your Excel under the INSERT tab. If you dont see it you might need to activate it in Add-Ins menu. You should the following window: In the dropdown list on the bottom of the window select COM Add-ins and click GO. Now select Microsoft Power Map and click on OK button to activate it. In this method you need to have two separates columns for latitudes and longitudes. There are a couple of cool things you can do with that and we will cover it in the future GeoawesomeHoTo. Today lets focus on another great option of the plugin geocoding. For the purpose of this tutorial I took a list of the largest agglomerations by population from Wikipedia. Selected the table in a web browser and copied it directly to Excel. Than I pressed Text to Columns button in the DATA tab and I came up with the following table. It will automatically connect the record to a centroid of a city or a country without a need to give a geographic coordinates. Below you can see that plugin automatically detected two parameters from our table City and Country. Based on these two columns Power Map will join the name to a centroid of a Country or a City on our list. In that case we are interested in visualizing the data for cities, so we should select only this option. In our case weve got only the Population column, so we should select it. Below that there is a menu to select how you want to visualize the data. You can Flat the map, you can select one of the predefined map themes, add text description (via Text Box) and so one. Under settings menu on the right side you can change the opacity, size and thickness of your data points. The size of the bubbles will change with the map scale so you can select Lock current scale if you want to keep make them look the same when you zoom in or zoom out. ![]() As a son of a professor of cartography I was surrounded by maps all my life and as a result spatial way of thinking and seeing reality is naturally embedded in who I am.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |