Excel 2016 came with a lot of new features, one of those was a big number of charts that were implemented after several years of no new ones.
What is a Filled Map?
A filled map chart is used to visualize selected data within a geographical blank map. It is useful when you want to display certain statistics by region.
We are going to show you today how you can create one.
How to create a Filled Map?
To make a filled map chart, the first thing you have to do is have a set of data ready. This works if, for example, the sales are divided by cities, countries, or other types of regions. Then you will want to convert that set of data to geography.
You are going to do that now:
- Select the data that you want to be displayed
- Find the "Data" tab that is located on the ribbon
- When you click on it, you will want to head to the "Data Types" section
- And then select "Geography," and everything will be converted
After that, icons that resemble maps will appear next to the regions that you converted, and they will be automatically connected with the bing maps.
Now you will want to insert the chart:
- Selected that set of data
- Find the „Insert" tab that is located on the ribbon
- Click on it, and then head to the „Charts" section
- Open the „Maps", and select the „Filled Map" chart
Once you've done that, a map will be formed, where all your data will be visually displayed by countries.
How to format a Filled Map?
If you want to manage your chart's settings, you will need to select it first. Then you will find two tabs on the ribbon, „Chart Design" and „Format".
Click on the chart and you will get a „Format Plot Area" pane where you can choose how to fill a certain region.
Also, you can double-click the chart so the „Format Object Task Pane" will appear. There will be a number of series options which you can adjust.
Map projections - You can change how the map is going to be projected.
Map area - You can change how much the map is going to be zoomed in, from a single state/province to the entire world view.
Map labels - You can manage how the labels fit. You can, for example, make geographical names visible.
If you head right to the "Design" tab, you will find on the left side of the screen a section that is called "Add Chart Element", or you can just click the plus sign that appears when you click on the chart.
If you do it, you will have three options where you can choose to add a:
Chart Title - Here you can obviously set how the chart is going to be named.
Data Labels - There you can find the "More Data Label Options" option where you can set up in detail how the label is going to look.
Legend - And the legend, which just adds a legend to one side of the chart.
The map chart is certainly useful. It is a nice addition to Excel that will now allow you to visualize certain data on a world map.
It can be problematic if a city or a state shares its name with others. And if you want to update the map, you will need to be connected to the internet.
Regardless, it is very useful, and the visuals are well made. We would recommend this chart to everyone.
Further reading: How to insert Treemap in Excel