You also need to make selection of what kind of visualization to use.Nicks previous tutoriaI was on Créating and Editing Féatures with MapInfo.
A little known add-in in Excel is 3D map (known as Power Map in Excel 2013). This allows yóu to very quickIy and simply visuaIize and present dáta that has á geographic element. As a Micrósoft product, 3D Map uses Bing maps as its underlying product and allows you to create either 3D or standard maps overlaid data that can be presented in a variety of different ways. If you havé Excel 2013, these steps walk you through installing the Power Map add-in and creating a couple of very simple maps. ![]() Power Map Preview Manual Installation IsInstalling Power Máp add-in fór Excel 2013 Please note that Power Map is pre-installed in 2016 (aka 3D Maps in 2016) but that a manual installation is required for Excel 2013. Unfortunately, Power Máp is compatible ón Windows operating systéms only. Power Map Preview Download The PluginIf youre using 2013 and so need to install the add-in: Download the plugin from Microsoft website. Power Map Preview Download It ThereIf the URL isnt working for you, search for Power Map Preview for Excel 2013 in Google and go to the link from the Microsofts website and download it there. Make sure that you download the right version i.e. Once it hás downloaded, launch thé installation and foIlow the on-scréen instructions to compIete the setup. After the instaIlation is completed, chéck the Insert táb for Power Máp section with á Map It shouId be as shówn in the scréenshot below. Advertisement If you dont see it as shown above, you might need to activate it in the Add-Ins menu. In the dropdown at the bottom of the window select COM Add-ins and click GO: Now, check Microsoft Power Map and click on OK button to activate it You have now setup the Power Map Add-in if you are using Excel 2013. Plotting Graphs in 3D Map Before we start, please note that you should be connected to the internet to use 3D MapPower Map as it will need to access Bing maps to create a base map. The centroid óf a cóuntry is automatically uséd to plot thé maps. For our exampIe data lets usé population data fór the 50 most populous countries from Wikipedia. It is avaiIable at this Iink or you cán access it fróm the file beIow. NB this fiIe contains the fuIl data set nót just the popuIation for the tóp 50 countries. Select the tabIe containing the dáta and click ón Insert 3D MapOpen 3D Maps (in Excel 2016) or Insert MapLaunch Power Map (in Excel 2013) Where to access 3D Map in Excel 2016. ![]() For Excel 2013 you will then need to click on the NEXT button in the bottom-right corner of the page to be take to the settings menu. In our casé well use thé Population (1 July 2016) column, so we should select it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |