Show Map Inside Power View in Excel 2013

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.

Step 3

Now enter some data like this:

Step 4

Now select the insert menu option.

Step 5

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

Step 6

A Power View window will appear like this:

Step 7

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

Step 8

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

Step 9

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

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:

Step 11

The map will appear like this:

Step 12

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

Step 13

The map will appear like this:

Step 14

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

Step 15

Now the map will look like this:

Step 16

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

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