contador web Saltar al contenido

How to: Insert and Set Up Dynamic Maps in Excel Spreadsheets | Productivity

Excel provides a function that allows you to link data to pivot maps. The spreadsheet editor searches for editable images in Bing to assemble maps with the indicated cell metadata. The feature is useful for drawing diagrams with information of a particular area and connecting them to the geographical figure of the place in question. The user can change colors and customize the map as desired. Learn how to create dynamic maps with Excel spreadsheet data in the following tutorial.

How to make pie chart in Excel

Learn how to import a map with data in Excel Photo: Carolina Ochsendorf / TechTudoLearn how to import a map with data in Excel Photo: Carolina Ochsendorf / TechTudo

Learn how to import a map with data in Excel Photo: Carolina Ochsendorf / TechTudo

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. Go to Insert and select from the spreadsheet the data you want to use to create a map reminding you to count valid city, state or country names. Then right-click on the Maps alternative and tick the drawing of the extendable tab;

Select the cells and, on the Insert tab, click on Maps and press the highlighted option. Photo: Reproduction / Daniel RibeiroSelect the cells and, on the Insert tab, click on Maps and press the highlighted option. Photo: Reproduction / Daniel Ribeiro

Select the cells and, on the Insert tab, click on Maps and press the highlighted option. Photo: Reproduction / Daniel Ribeiro

Step 2. The program imports the Bing platform map image, allowing you to edit the format and style from the options on the Design tab. However, you can also click on the map design to edit the title, change the size or access customization options faster;

Select map to view Design tab options or edit title and size Photo: Playback / Daniel RibeiroSelect map to view Design tab options or edit title and size Photo: Playback / Daniel Ribeiro

Select map to view Design tab options or edit title and size Photo: Playback / Daniel Ribeiro

Step 3. You can also modify the background and data marking colors on the map by shortcut to the design features. To do this, select the imported image and press the cone shaped like a brush;

To change map colors, select it and click on the brush-shaped icon. Photo: Reproduo / Daniel RibeiroTo change map colors, select it and click on the brush-shaped icon. Photo: Reproduo / Daniel Ribeiro

To change map colors, select it and click on the brush-shaped icon. Photo: Reproduo / Daniel Ribeiro

Step 4. Another configuration option is the editing alternatives for each graphic element of the map, which can be included, modified font and colors or excluded. To do so, click on the picture and press the icon with the + symbol;

To configure the map graphics, click on it and choose the icon with symbol + Photo: Reproduction / Daniel RibeiroTo configure the map graphics, click on it and choose the icon with symbol + Photo: Reproduction / Daniel Ribeiro

To configure the map graphics, click on it and choose the icon with symbol + Photo: Reproduction / Daniel Ribeiro

Step 5. Importing maps by Excel is driven by the limitations of the Bing platform. Therefore, it is important to check country or state nomenclatures in Microsoft Search before using the feature. Thus, using data with country, state and city names, it is possible to create maps of the globe or specific to each country or region of the world.

Import and dynamic maps comply with country, state or city nomenclatures limitations on the Bing platform Photo: Reproduction / Daniel RibeiroImport and dynamic maps comply with country, state or city nomenclatures limitations on the Bing platform Photo: Reproduction / Daniel Ribeiro

Import and dynamic maps comply with country, state or city nomenclatures limitations on the Bing platform Photo: Reproduction / Daniel Ribeiro

How to solve timeline problem in Excel? Ask questions on the TechTudo forum.

How to watermark Microsoft Excel spreadsheets

How to watermark Microsoft Excel spreadsheets