How to use alias tables

The Custom alias table can be used to give alternative names to regions. It can be useful for creating map charts in your native language, if it's different from English.

1. Use alias names to localize countries (as a translation)

  • Add the official name of a region in the first cell
  • The cells to the right each contain an alias for this region

Map Chart alias example 1

If it is more convenient, you can also enter each alias definition on a separate line:

Map Chart alias example 2

  • Start to make a map chart. Add the name to visualize with its data.
france_data

 

  • In dialog page 2, add your cells containing alias names (Custom alias table)
Map Chart dialog page 2


In this case, your map chart will look like this:

alias_map_france

 

2. Instead of a country localization, you can use any other custom names, too. More steps are the same to localize countries.

3. You can use an alias table to define custom regions that are made up of already existing ones. If you give the same alias to two or more regions, the alias name will correspond to a region that is the union of the original regions.
The Custom alias table is completely optional. Just leave this field empty if it is not needed.

You can make a custom region map chart as follows:

  • Add the names, that you want to visualize with its data range
eu_alias_names

 

  • In another sheet, add an alias table (here you can see a part of the countries of Europe. In this example, we visualize two custom regions in Europe, EU member countries and countries out of EU.)
eu_alias_part_table


The result of this map will look like this:

alias_map_eng