{"id":490,"date":"2015-01-11T14:35:58","date_gmt":"2015-01-11T14:35:58","guid":{"rendered":"https:\/\/grindgis.com\/?p=490"},"modified":"2018-04-05T14:30:09","modified_gmt":"2018-04-05T14:30:09","slug":"create-maps-on-microsoft-excel-2013-using-power-map","status":"publish","type":"post","link":"https:\/\/grindgis.com\/?p=490","title":{"rendered":"Create Maps on Microsoft Excel 2013 using Power Map"},"content":{"rendered":"

Microsoft Excel 2013 has the capability to draw nice map. The number that are on your sheet can be plotted on the map without living the Excel. No need of any fancy GIS software to draw it. You can create 3D map too. Bing maps is used as a base map. Map can be a globe or flat format. Power Map has all the options available to create great looking maps. It is a plugin used to draw maps on it. User need to download<\/a> this plugin from the Microsoft official website. Below is the step by step process to create a map along with other features.<\/p>\n

Step by step to draw the maps on the Power Map
\n<\/span><\/h2>\n

First step is to download the plugin.<\/p>\n

Downloading the Plugins
\n<\/span><\/h3>\n

1.<\/strong><\/span> Go to the Microsoft official website to download the plugins.Download<\/a>
\n<\/strong><\/span><\/p>\n

2.<\/strong><\/span> Then run the setup wizard by clicking the downloaded file Microsoft Power Map Preview for Excel.exe
\n<\/em><\/strong><\/p>\n

\"Microsoft<\/p>\n

3.<\/strong><\/span> Then press Next<\/strong> and checked the I Agree button<\/strong>, again press Next.<\/p>\n

4.<\/strong><\/span> After all the above process the Power Map will run for a while to install all the required files. After finishing the installation click close.<\/p>\n

\"Microsoft<\/p>\n

5.<\/strong><\/span> Then open the Microsoft Excel, if it does not show Power Map icon on the Insert tab. Then follow the a , b and c<\/strong> process to activate, if not just go to step 6.<\/p>\n

\"Power<\/p>\n

Step to Add Power Map Tab if it does not show.
\n<\/strong><\/span><\/p>\n

    \n
  1. Go to File <\/strong>> Options<\/strong> > Add-Ins<\/strong><\/li>\n
  2. In the\u00a0Manage<\/strong>\u00a0box, click the drop-down arrow >\u00a0COM Add-ins<\/strong>\u00a0>\u00a0Go<\/strong><\/span><\/li>\n
  3. Check the\u00a0Microsoft Power Map <\/strong>>\u00a0OK<\/strong><\/span><\/li>\n<\/ol>\n

    \"Microsoft<\/p>\n

    \"Microsoft
    \n6.<\/strong><\/span> I have copied 50 largest populated cities in Canada from the Wikipedia. You can     download<\/strong><\/a> the clean data or you can get from Wikipedia<\/a>. Our target is to plot different type of maps from this data.<\/p>\n

    \"Microsoft<\/p>\n

    7.<\/strong><\/span> Then click on the Lunch Power Map from the Map icon.<\/p>\n

    \"Lunch<\/p>\n

    8.<\/strong><\/span> It will take a few minutes to load the Map window and below is the map screen window.<\/p>\n

    \"Map<\/p>\n

    Make sure Census Subdivision<\/strong> is checked. Because we want to plot all the cities values. After all this click Next.<\/p>\n

    9.<\/strong><\/span> On the next window we will select the fields that we want to draw. See the image below. Check the Population 2001 and Population 2011, we will draw the bar chart diagram, by default it will draw bar chart.<\/p>\n

    \"Population<\/p>\n

    On the map by default it will show the legend you can close it by clicking x button. If you need that back again then click the legend button. You can zoom in zoom out, adjust north or the map according to your need.<\/p>\n

    \"Population<\/p>\n

    10.<\/strong><\/span> You can change the charts to clustered type by checking the clustered column. Map look will change. In same way we can change map type to heat map, bubble and to region (thematic map).<\/p>\n

    \"Microsoft<\/p>\n

    11.<\/strong><\/span> On the below map the option is bubble with province total 2011 population.<\/p>\n

    \"Microsoft<\/p>\n

    12.<\/strong><\/span> Now to change the color click on the setting tab and change the blue color to green. Change the formatting option to get the better look. See below image.<\/p>\n

    \"Microsoft<\/p>\n

    \"\"<\/p>\n

    \u00a0\u00a0\"Power<\/p>\n

    Some other options on the map.<\/span><\/h3>\n

    You can change the Themes of the map.<\/p>\n

    \"Themes<\/p>\n

    You can add labels on the map by clicking map labels button.<\/p>\n

    \"Label<\/p>\n

    You can change the shape of icons by selecting type of symbol from the shapes button.<\/p>\n

    \"Icon<\/p>\n

    You can create a flat map by clicking the flat map button.<\/p>\n

    \"Flat<\/p>\n","protected":false},"excerpt":{"rendered":"

    Microsoft Excel 2013 has the capability to draw nice map. The number that are on your sheet can be plotted on the map without living the Excel. No need of any fancy GIS software to draw it. You can create 3D map too. Bing maps is used as a base map. Map can be a […]<\/p>\n","protected":false},"author":1,"featured_media":495,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,43,29],"tags":[46,53,51,50,45,54,52,44,47,55,48,49],"class_list":["post-490","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-microsoft-excel","category-software","tag-46","tag-bar-diagram-on-the-map","tag-bing-map","tag-charts-on-the-map","tag-excel","tag-excel-sheet","tag-globe-map","tag-microsoft","tag-microsoft-excel-201","tag-populatoin","tag-power-map","tag-step-by-step-tutorial","entry","has-media"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=490"}],"version-history":[{"count":0,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/490\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/media\/495"}],"wp:attachment":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}