Welcome to Day 2 of our effort to visualize the Olympics using Power View in Excel 2013. In yesterday’s post we started with a simple table of data in Excel and turned it into a map displaying the number of participants in the Olympics by country. While the accompanying video is about two minutes long, if you just walk through the exercise you will find that in the worst case it takes only 6 clicks and one drag operation to create this map in Excel.
For the second exercise, we are going to pick up where we left off from yesterday. You can download this starting workbook here.
First, select the map and then let’s click on the Gender category from the field list. As soon as you do this, you will notice that the bubbles on the map will turn into pie charts displaying the percentage of men and women participating for each country.
Notice also that when you click on the entries in the legend the slices of the pie chart highlight that represent that entry.
As an example, clicking on “M” highlights all of the slices that represent male athlete participation. Here I’ve also zoomed into the map to center the map in Europe.
Now let’s break this data out by different sports. To do this, place the “Sports Name” field on Tiles Drop Zone. Now you can flip through versions of this map by each sport.
Once you place the map inside of the Tiles container, there is additional option that becomes available. This option allows you to synchronize the bubble sizes across all of the map tiles. As a result, the sports that have more athletes participating in them will have the largest pie charts across all of the map instances. If you decide to leave the map in it’s default state, each map will compute it’s own maximum pie chart size. To set this option, simply select the map and go to the Layout section of the ribbon. There you will find the Synchronize Bubbles Option where you can set them to be aligned across all tiles instances.
Go ahead and click through some of the sports. You will find some interesting data points.
In tomorrow’s post, we will start to work in the PowerPivot add-in so we can add some images to this report.