How to use the Geography data type to quickly add a map chart in Excel

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel’s Geography data type, creating a map chart is easier than you might think.

Most will agree that a picture is worth a thousand words, and where geographical data is concerned, it’s never been easier to create that picture. We can thank Microsoft Excel’s geographical data type for the ease of implementing geographical charts. It’s almost like doing no work at all—almost. In this article, we’ll discuss the Geography data type and then use it to display data in a map chart.

SEE: 83 Excel tips every user should master (TechRepublic)

I’m using Microsoft 365 on a Windows 10 64-bit system. Although this feature is available in Web Online mobile apps, it isn’t available in earlier desktop versions. You can work with your own data or download the .xlsx demonstration file. This article assumes…

Keep reading the full content on the TechRepublic site.

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Comment