Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to insert and edit a power view map in Excel?

Suppose you have a table listing some countries and revenues, you want to display them in a map as below screenshot shown, how can you solve it in Excel? Here I am going to tell you how to insert and edit a Power View map in Excel.

doc insert power map 1
doc insert power map 2

Insert and edit a Power View map


Insert and edit a Power View map


Before inserting a Power View map, you may need to enable Power View feature first (How to insert or show Power View in Excel?).

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. 

Note: Power View feature only works in Excel 2013 and Excel 2016.

Insert Power View map

1. Select the range you want to create a map, click Insert > Power View. See screenshot:
doc insert power map 3

2. In the Insert Power View dialog, check Create a Power View Sheet option or the other option as you need. See screenshot:
doc insert power map 4

3. Click OK, and a new Power view sheet has been created with the selection contents, and the Power View tab displayed in ribbon as well. See screenshot:
doc insert power map 5

4. Click on the range to display the Design tab, and then click Design > Map. See screenshot:
doc insert power map 6

5. A warning message will be added above the sheet, please click Enable Content to go ahead.
doc insert power map 7

Then a map has been inserted in the sheet. See screenshot:
doc insert power map 8

Adjust and edit Power View Map

Enlarge or shrink the map as you need by dragging the corner of the map. See screenshot:
doc insert power map 9

Place mouse at the above of the map to adds a title for the map.
doc insert power map 10

Add data labels to the map by clicking Layout > Data Labels, choose one type as you need./p>

doc insert power map 11
doc insert power map 12

Choose the map background as you need by clicking Layout > Map Background. See screenshot:

doc insert power map 13
doc insert power map 14

Filter data in the map. Go to right Filters pane, under Map section, check the data you want to filter.
doc insert power map 15

Filter by country name
doc insert power map 16

Filter by revenue
doc insert power map 17


Relative Articles


Recommended Productivity Tools for Excel

kte tab 201905

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.