The bigger a circle the bigger our revenue is. In order to enlarge the map, click in the bottom right corner and move your mouse cursor to the right and down.Īs you can see, the countries from your Excel Sheet ( South Africa, France, Italy and Bolivia) are now displayed on the map:īlue circles on the map show the revenue. Once enabled, a new sheet will be created for our Power View reports: If you receive the message that your current security settings do not allow this file to be downloaded, visit Your current security settings do not allow this file to be downloaded to solve the problem. Click on the Install Silverlight link to get it. You will see a message offering to install the program. Silverlight is a tool for creating interactive applications, and it is required to generate Power View reports. Please note that you will need Silverlight installed. If it is the first time that you use Power View you will be prompted to enable the feature. To do this, go to the menu and select the tab Insert -> Power View.
The next step is to create the charts with Power View. Then click on the Format as Table icon and pick a table style.
So, let's create a report with maps.įirst, select your data. We want to see the revenue per country on a World Map using Excel. We have countries, the revenue and the number of customers in an Excel Sheet.
In this article you will learn how to create cool reports in Excel. Sometimes we need to get sales reports and we want to identify regions and patterns of sales related to the customers. It is an extremely powerful reporting tool. The latest version comes with the Power View. Yes, now it is possible to work with nice charts that have Maps in Excel 2013.
0 kommentar(er)
