If you add small region details such as city, county, states, it allows the map to have a better projection of the region and your chart looks more accurate subsequently.

You may have sales for different geolocations or product details.

Also, we might not be always having tools like ArcGIS or QGIS with us to make good graphical maps.

Moreover, it takes a lot of time to generate maps through these tools as well.

Now, we can use excel maps to generate fancy maps and map charts for such type of data and that too within a jiffy when your data is ready.

Use these map charts whenever you have data is sort of geographical regions such as countriescontinents, city, state, postal codes, county, etc.

Excel Map How To Create The

Lets understand how to Create the Map Chart in Excel with a few practical steps.

Suppose we have data as shown below which contains our sales values for different countries.

Select Inset and in chart options, you can see the Maps option there.

Excel Map Series And Country

Excel is smart enough to populate the sales values into series and Country into a category.

Out of all those operations, select the Format Chart Area option which is situated at the bottom most part of the operations list.

Here you can customize the Fill color for this chart or you can resize the area of this chart or can add labels to the chart as well as axis.

Click on Chart Title and add the title as Country-Wise Sales for this chart.

This allows you to make customized changes into series data (numeric values in this case).

Like under Series Options, you can change the Projection of this map, you can set the Area for this map as well as you can add Labels to map as well (remember each series value has a country name labeled).

However, the most interesting and important feature is, we can change the color of series values.

It will open up a list of colors that are used by default while creating this map chart.

It ideally chooses the following color combination by default.

So that it gives a better understanding through the graph itself (No need to go to the values table).

It allows you to differentiate your series into three different patterns: Minimum, Midpoint and Maximum (based on the series values and colors assigned to them).

Here we tried to cover how to create a map chart in excel 2016 and have seen some customization options available with map chart.

Therefore, it becomes more important to provide as smallest possible region information as possible to get the adequate data.

Having said that, every time you generate a map chart, the system suggests how much region (in terms of percentage can be covered).

Excel Map For Mac