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…