How to Make a Map Chart in Excel - Tutorial ????️ ????

Excel tutorial on how to use Map Charts in Excel to create a map directly in your spreadsheet. You can create a map to show values and categories by geographic area - worldwide, by country or closer!

You can make 2 types of map charts using Excel:
1. either based on values (dollars, for example) or
2. category (an example would be product types)

A value type chart map will chart values on the geographic region in your data set. This is also an easy way to make a heat map in Excel!

A category type map chart will chart your list by location. This is for anything that is not numeric. In our example, we use zip codes to map the locations where our products were sold.

You can also choose the map projection you'd like. In this example, our options were:

Albers - which is conic shaped
Mercator - cylindrical and
Miller - also cylindrical

For more detail and for information on other types of map projections, please visit: en.wikipedia.org/wiki/Map_projection

If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/

*************************************

For more on how to use charts in Excel, take a look at these other tutorials:

How to Make a Pivot Table Chart in Excel - Tutorial: youtu.be/BJJMttQFzzA

How to Make a Goal Thermometer in Excel - Tutorial: youtu.be/J3v0R6URaAo

How to Insert a Picture in a Chart in Excel / Make a Pictograph in Excel - Tutorial: youtu.be/O3Jj7n29rlo

How to Use Excel Sparklines: youtu.be/6aUv1E9IZnc

and

To learn how to use data in Excel to create a Google Map, make sure to watch:

How to Make a Google Map from Excel - Tutorial: youtu.be/QpoFpIaSjdc

*************************************

*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365

The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia

Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends – it really helps us out 😊

To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube

Thanks!

*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!

#YAcostaTutorials