How to show regional results on custom regions? (Example for France Departments)
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.
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.
Filled map functionality of the Excel Map allows user not only to differentiate the shapes colors by values (which is sometimes called a choropleth map) but also to color them by categories. Using Excel Map France Postcodes (Code Postal) I will show you how to create your own regions.
A dashboard is usually a collection of charts and tables combined with interactivity for the end user. Excel Map software allows the user to easily create interactive dashboards using pivot tables and slicers. This example is based on a Excel Map UK but can be applied to any of the maps.