In this tutorial I’d like to present on how to use European Union statistics to create your own filled map in Excel. The tutorial is based on our Excel NUTS 0-1-2-3 Europe Map that you can find in our online shop.
Based on our Excel Maps for different countries we’ve just released a brand new map called Custom Excel Map. This map allows you to design your own shapes and work with them with colors, bubbles, column charts and pie charts. It enables creating a map that you need – for your factory, warehouse, custom map…
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…
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…
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.