Reader Level:
Articles

Show Map Inside Power View in Excel 2013

By Megha Goyal on August 28, 2012
In this article we will discus how to use the map in Power View in Excel 2013.
  • 0
  • 0
  • 6096

There is a special feature in Excel 2013 for inserting maps into our Power View report. By doing this we can analyze the data in terms of the map. If we have a set of data and we want to analyze the data through the map in Excel 2013 then we must follow various of steps.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now select the blank workbook template from the available templates.

mapinpowerview1.jpg

Step 3

Now enter some data like this:

excelpowerview1.jpg

Step 4

Now select the insert menu option.

Excelpowerview.jpg

Step 5

Now under it just select the Power View option like this:

powerviewinexcel.jpg

Step 6

A Power View window will appear like this:

powerviewmap.jpg

Step 7

In it just deselect all the fields from the Power View Fields task pane and leave the state checkbox checked.

excelpowerviewmap.jpg

Step 8

Now click on the Map option under the design menu option.

powerviewmapinexcel.jpg

Step 9

A map will be inserted like this which will show all the states in the country of Australia:

powerviewmap (2).jpg

Step 10

Now while selecting this map just drag and drop Education from the Power View Fields task pane into the COLOR Option like this:

powerviewmap (3).jpg

Step 11

The map will appear like this:

powerviewmap (4).jpg

Step 12

Now drag and drop the Education Power View Field into the Horizontal Multiples Text Field like this:

powerviewmap (5).jpg

Step 13

The map will appear like this:

powerviewmap (6).jpg

Step 14

Now drag and drop the Number of sites visit Power View Field into the Size Text Field like this:

powerviewmap (7).jpg

Step 15

Now the map will look like this:

powerviewmap (8).jpg

Step 16

If we will click on a particular spot on the map then it will show the information like this:

mappowerview.jpg

Thus in this way we can analyze the data through the map in the Power View in Excel 2013.

COMMENT USING

Trending up