If you are trying to analyze what is going on in your logistics, you might need the flow map that will show where your distribution centers are and where you send your products to. With Excel Map it’s really easy to customize a map like this to show with arrows the direction of your flow.
Sometimes you may want to attract the audience with a non-standard map. One of the ways to do it is to use a graphic instead of clean data visualization like bubbles. With Excel Map you can easily replace the bubble shape with an image.
If your data contains addresses (or just part of it like city or post code) you can try to show the data on the map. Although Excel Map does not support zoom in like Google Maps or any other Internet map do, it can give you an overview on where your addresses are (e.g. of the customers). But how to turn an address to a point on the map?
There are two ways to create a quick filter for the bubble chart layer in the Excel Map: if you are Excel 2013+ user, you can create a slicer or you can create a non-standard filter based on your list.
What is the problem with the filled map? You can show only 1 measure on a map at the same time. What if you would like to show two of your KPIs: the size of the sales and the target realization? Use colored bubble chart.
What is the best way to quickly compare your results on a map between consecutive years? Check the Choose data range option that allows you the quickly switch between various options.
What if your map has parts that are very detailed? No problem. You can use a great built-in Excel functionality called Paste as Linked Picture. Just copy & paste cells behind the shapes and edit the picture.
If the map has two administrative levels (like Excel Map France, where there are Regions and Departments) you can easily drill down and up between these levels using Hide shapes functionality. The example will be based on the population data for France.
The most important decision to be made when designing a filled map (professionally called a choropleth map) is to define colors classes. As the designer, you decide which value goes to which color. Your decision will have a great impact on what the audience will get from your map. Get to know 3 ways to find to classify your data.
The default label in Excel Map, that is shown after clicking the shape (or a point on bubble chart), shows the name of the area, its parent (if there is any) and the value that can be found in the column G of Data sheet. How to edit this label?