How to compare consequtive years on the map?
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.
How to enlarge detailed parts of the map? Example for Excel Map France
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.
How to drill down on Excel Map France?
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.
How to classify your data on a filled map (choropleth map)? Population on Excel Map 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…
Details
How to change the shape labels? – Example for Excel Map France
The default label in Excel Map, that is shown after clicking the shape (or a point on bubble chart), shows the name of the area, its parent (if there is any) and the value that can be found in the column G of Data sheet. How to edit this label?
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.
How to build custom regions in Excel Map? – Example for France Departments
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.
3 ways to count filled map ranges in Excel Map United Kingdom
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.
How to build your own regions & areas? – Example for Excel Map France Postcodes (Code Postal)
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.
How to create an interactive Excel dashboard with slicers? – Example for Excel Map UK
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.