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