Map

Map

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

Plots data across geographical regions onto a map.

Can be used with countries/regions, states, counties or postal codes.

Links to online geography data types to convert categories into recognized values.


Data Format

  • x-axis: Categories (e.g. countries)
    • Categories are color-coded on the map.
  • y-axis: Data Series (e.g. population or GDP per capita)
    • Series are plotted onto the map and color-coded according to a numeric scale.
 Series
Category 1 #
Category 2 #
Category 3 #

Try it now!

  • Select a data type using the dropdown list to generate the relevant map.
  • The chart, title and values adjust to reflect the data for each country.
  • In the event the embedded map does not display, static images are provided below.
map population map migration
map gdpcapita map surface
  • These maps were built using data validation lists, named ranges, conditional statements and the MATCHOFFSET and VLOOKUP functions.

 

Maps

Latest Additions

26 March 2022
26 March 2022
26 March 2022
25 March 2022
22 March 2022
21 March 2022

Register (for free!) or Login to access bonus materials

About xlsnippets

Learn how to master functions, charts, pivot tables and more using Excel for Microsoft Office 365. Simple instructions and embedded spreadsheets help you practise the basics.

Latest Updates

26 March 2022
26 March 2022
26 March 2022
25 March 2022
22 March 2022

Coming soon

xlsnippets.com is currently in beta version. More functions and bonus content for registered users will be added weekly. Detailed training courses with additional downloadable resources are also on the horizon!