

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. Yes, now it is possible to work with nice charts that have Maps in Excel 2013 and later versions that come with the Power View.
