The other column will usually be metrics relevant to the locations listed, like population, tax revenue, gross domestic product, unemployment rate and so on. One of the columns must be geographical data points, like names of countries or cities. The feature, found in the Insert menu of Excel, culls data from a selected cluster of cells. The best answer to this question is 'yes and no.' What you end up making is a ' map chart', which is an insert in the middle of an Excel sheet adjacent to one of the tables on it. We'll also go over how you can better leverage your Excel data for geographic analysis by using eSpatial's heat mapping features. In this post, we'll cover the mapping functions – and limitations – in Microsoft Excel. What you need instead is a comprehensive tool for sales territory mapping like eSpatial. After all, it's a data analysis tool primarily focused on the simple but effective spreadsheet format – it was never meant to be a mapping method.

However, there are notable limits to what you can do with a map chart in Microsoft Excel.

The ability to create maps in Excel is one of the useful features of the signature Microsoft Office spreadsheet software.

Microsoft office draw map