Create A Map Chart In Excel 365

Insert Maps in Excel 365

Now in Excel 365 we can use a Map Chart to compare values and show categories across Geographical Regions. We use a Map Chart when we have Geographical Regions in our spreadsheet such as CountriesRegionsStatesCounties or Postal Codes. To find out how to create a Map Chart in Excel 365 just keep reading.

We should have one column for our geographic location (country/region, state or province, county or postal code), then our numeric or categorical values in the second column. We might also need to add another level of geographic detail.

As we can see in the image below, in the Spreadsheet I have inserted data that contains Countries and the Population of each country. *Note that the inserted data has been formatted as a table.

Inserted Data

Once we have the necessary data inserted in our Spreadsheet, we select the Insert tab and then we locate the area of the ribbon named Charts as shown below.

Insert Chart - Maps

Then all we have to do is to select the Maps command from the area of the ribbon named Charts, and from the drop down menu that appears we select the command Filled Map.

Maps - Filled Maps

In the image below, the Filled Map command is selected from the Maps drop down menu, and straight away a Map has been inserted in our Spreadsheet per the Data that we had inserted.

Inserted Map

In the next image, I have moved the Map Chart to a Worksheet on its own, in order to view all the details. The Design and Format tab have been activated on the ribbon, where we can use the available commands in order to change elements on our Map Chart.

The available commands in order to modify our Map Chart are the following:

Chart Layouts:

  • Add Chart Element: We can add a Chart Title, Data Labels or a Legend.
  • Quick Layout: We can quickly change the overall Layout of the Chart.

Chart Styles:

  • Change Colors: We can customize the Color and Style of the Chart.
  • Chart Styles: We can change the Style of the Chart with one of the available ones.

Data:

  • Switch Rows/Columns: This command is not available in Map Charts.
  • Select Data: We can change the Data Range used in the Chart.

Type:

  • Change Chart Type: We can change to a different Type of Chart.

Location:

  • Move Chart: We can move the Chart to another Sheet or Tab in our Workbook.

Sort:

  • Sort: This command is not available in Map Charts.

In the image below, we also notice the Format Task Pane appears at right of the window. We can use this Task Pane in order to modify and format our Map Chart in many more ways.

Design Tab - Map

For example: By using the Format Task Pane, I have selected the Format Data Series as shown in the image below. Here we can change the Options for the Series of our Map. We can choose for the Map Projection one of the available commands:

  • Αυτόματα (Automatic):
  • Mercator: The Mercator projection is a cylindrical map projection presented by the Flemish geographer and cartographer Gerardus Mercator in 1569. It became the standard map projection for nautical purposes because of its ability to represent lines of constant course, known as rhumb lines or loxodromes, as straight segments that conserve the angles with the meridians.
  • Miller: The Miller cylindrical projection is a modified Mercator projection, proposed by Osborn Maitland Miller in 1942.
  • Robinson: The Robinson projection is a map projection of a world map which shows the entire world at once. It was specifically created in an attempt to find a good compromise to the problem of readily showing the whole globe as a flat image.

Map Projection

In next image I have selected the Map Area command from the Series Options, and from the drop down menu we can either select:

  • Automatic
  • Only Region With Data
  • World

Map Area

In next image I have selected the Map Labels command from the Series Options, and from the drop down menu we can either select:

  • None
  • Best Fit Only
  • Show All

Series Options - Map Labels

Below you can check out the video describing How To Create A Map in Microsoft Excel 365.

Sources used:

https://en.wikipedia.org/wiki/Miller_cylindrical_projection

https://en.wikipedia.org/wiki/Robinson_projection

Advertisements

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on January 11, 2017, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Create A Map Chart In Excel 365.

Comments are closed.