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.
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.