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.
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.
In the previous tutorial, we’ve ended up with a custom regions map. Now let’s use it to show how well our regions meet corporate KPIs.
Excel Map is extremely flexible when it comes to designing custom regions. When your regional division is based on administrative areas or ZIP codes, you can use our Excel Map to quickly show the regions, draw the boundaries and add any labels on top.
Using filled (choropleth maps) may be a little tricky. Every time you change the color range values you get a different map. That is why it is crucial to choose a proper method to define the legend ranges. You can find here three most common ways.