How to enable map chart in excel 2016

Creating a map in Excel might seem like a daunting task, but it’s actually quite straightforward once you know how. In a nutshell, you’ll be using Excel’s built-in mapping tool to plot your data onto a map of your choice.

You’ll need some geographical data to get started, like the names of countries, states, or cities, and some values to plot, such as population numbers or sales figures.

Create a map in excel using latitude and longitude

Ready to dive in? Let’s get mapping!

Step by Step Tutorial: Creating a Map in Excel

Before we get into the nitty-gritty, it’s important to note that to create a map in Excel, you’ll need to have Excel 2016 or later, or a subscription to Microsoft 365.

These versions have a built-in feature called 3D Maps (formerly Power Map) that makes mapping a breeze.

Step 1: Prepare your data

Make sure your data is organized in a way that Excel can understand.

Your data should be in a table format with clear headings for each column.

If you’re using geographical locations, such as countries or cities, make sure they’re spelled correctly and consistently throughout your table.

Step 2: Insert a map

Go to t

how to add map chart option in excel 2016

insert map chart in excel 2016