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. What if I want to graph specific geographical coordinates on the map?.How can I specify the country and city with Power View?.This article is for newbies who want to learn about this exciting area. We will show countries, cities and specific geographical points. 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 Comments
Leave a Reply. |