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.

Preparing data for showing regional KPIs on Excel Map France

We will use the same data structure as in the previous example, but now I will modify the region numbers table. Instead of region number let’s put there KPI value. This simple example is based on two regions only but of course you can have many more.

This tiny table is connected by VLOOKUP function to the Data sheet and therefore to the map.

Showing regions results with traffic lights

Now let’s use built-in color palettes to show results as colors. Go to Choose colors > pick red-green palette and assign KPI levels.

Adding percentage formatting to map legend

If your KPI is formatted as percentage, you can turn on percentage formatting on Excel Map ribbon.

This is our final KPI map:

Watch the video tutorial to learn how to use the Excel Map

← All tutorials