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.
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.
Customers of Maps-for-Excel.com use our Excel maps in many ways. Here are the 4 most useful of them (examples based on the Excel Map of Poland).
Bubble chart allows to present 3 series of data at the same time – the figures are presented on the x and y-axes and by the bubble size.
The choropleth map is a chart presenting phenomena on the map and is one of quantitative methods in cartography. Intensity of a given phenomenon is displayed within defined reference areas, the most often of administrative division, e.g. provinces, municipalities/communes or districts, and the magnitude of the phenomenon is presented in classes (ranges).